formula help PLEASE
 

I have to pull data from one sheet to another depending on the date entered
on the first sheet
I want to enter todays date in C3 of sheet 1
I want the data in the second sheet from the row with the same date
Sheet 1:

REPORT DATE 4/11/2010

Genesis KPI's UOM
OUTBOUND DATA DATA
RECEIVING

Sheet 2

11-Apr 1 9 0 6
12-Apr

Is this a VLOOKUP?
Thnaks

formula help PLEASE
 

It sounds to me like a VLOOKUP will do the job for you: Assuming that your
list on Sheet2 starts at A2, something like this:
=VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False)
should work. The ",2," in that formula would return values from column B,
",3," would return values from the 3rd column of the table (column C), etc.

Just be sure that C3 and the dates in Sheet2 are of the same data type:
either real dates or text entries.

To guard against #N/A errors being displayed when the date you enter in C3
does not match any entry on Sheet2, wrap the formula this way:

=IF(ISNA(VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False) ),"",VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False))

(all on one line in Excel, of course).

"Norm" wrote:

I have to pull data from one sheet to another depending on the date entered
on the first sheet
I want to enter todays date in C3 of sheet 1
I want the data in the second sheet from the row with the same date
Sheet 1:

REPORT DATE 4/11/2010

Genesis KPI's UOM
OUTBOUND DATA DATA
RECEIVING

Sheet 2

11-Apr 1 9 0 6
12-Apr

Is this a VLOOKUP?
Thnaks

formula help PLEASE
 

JLatham,
This looks like it is exactly what I need
I just have to adjust to the 13 sheets in this report
Thanks You for your help

"JLatham" wrote:

It sounds to me like a VLOOKUP will do the job for you: Assuming that your
list on Sheet2 starts at A2, something like this:
=VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False)
should work. The ",2," in that formula would return values from column B,
",3," would return values from the 3rd column of the table (column C), etc.

Just be sure that C3 and the dates in Sheet2 are of the same data type:
either real dates or text entries.

To guard against #N/A errors being displayed when the date you enter in C3
does not match any entry on Sheet2, wrap the formula this way:

=IF(ISNA(VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False) ),"",VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False))

(all on one line in Excel, of course).

"Norm" wrote:

I have to pull data from one sheet to another depending on the date entered
on the first sheet
I want to enter todays date in C3 of sheet 1
I want the data in the second sheet from the row with the same date
Sheet 1:

REPORT DATE 4/11/2010

Genesis KPI's UOM
OUTBOUND DATA DATA
RECEIVING

Sheet 2

11-Apr 1 9 0 6
12-Apr

Is this a VLOOKUP?
Thnaks

formula help PLEASE
 

When I try to go across it works for 1, 2, 3, for colums A,B,C
I get a #REF in the cell
Am I changing something wrong
I have to go to column "T"

"JLatham" wrote:

It sounds to me like a VLOOKUP will do the job for you: Assuming that your
list on Sheet2 starts at A2, something like this:
=VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False)
should work. The ",2," in that formula would return values from column B,
",3," would return values from the 3rd column of the table (column C), etc.

Just be sure that C3 and the dates in Sheet2 are of the same data type:
either real dates or text entries.

To guard against #N/A errors being displayed when the date you enter in C3
does not match any entry on Sheet2, wrap the formula this way:

=IF(ISNA(VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False) ),"",VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False))

(all on one line in Excel, of course).

"Norm" wrote:

I have to pull data from one sheet to another depending on the date entered
on the first sheet
I want to enter todays date in C3 of sheet 1
I want the data in the second sheet from the row with the same date
Sheet 1:

REPORT DATE 4/11/2010

Genesis KPI's UOM
OUTBOUND DATA DATA
RECEIVING

Sheet 2

11-Apr 1 9 0 6
12-Apr

Is this a VLOOKUP?
Thnaks

formula help PLEASE
 

Check out Excel's Help for VLOOKUP() for specifics, but basically you need
to change the table address, the 'Sheet2'!$A$2:$E$100 address in the previous
formula (and I just noticed I left the second ' out of that, sorry).

Change it to reference your entire table range. Then adjust the column
number in it to pick up the proper column in that table. Assuming your table
goes from A2 to T100, with dates in A and you want to get information from
column T, then:
=VLOOKUP($C$4,'Sheet2'!$A$2:$T$100,20,False)
should do it for you.

If your dates were in column B on the 2nd sheet, then
=VLOOKUP($C$4,'Sheet2'!$B$2:$T$100,19,False)


"Norm" wrote:

When I try to go across it works for 1, 2, 3, for colums A,B,C
I get a #REF in the cell
Am I changing something wrong
I have to go to column "T"

"JLatham" wrote:

It sounds to me like a VLOOKUP will do the job for you: Assuming that your
list on Sheet2 starts at A2, something like this:
=VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False)
should work. The ",2," in that formula would return values from column B,
",3," would return values from the 3rd column of the table (column C), etc.

Just be sure that C3 and the dates in Sheet2 are of the same data type:
either real dates or text entries.

To guard against #N/A errors being displayed when the date you enter in C3
does not match any entry on Sheet2, wrap the formula this way:

=IF(ISNA(VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False) ),"",VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False))

(all on one line in Excel, of course).

"Norm" wrote:

I have to pull data from one sheet to another depending on the date entered
on the first sheet
I want to enter todays date in C3 of sheet 1
I want the data in the second sheet from the row with the same date
Sheet 1:

REPORT DATE 4/11/2010

Genesis KPI's UOM
OUTBOUND DATA DATA
RECEIVING

Sheet 2

11-Apr 1 9 0 6
12-Apr

Is this a VLOOKUP?
Thnaks

formula help PLEASE
 

When I try to go across it works for 1, 2, 3, for colums A,B,C
Sounds good
I get a #REF in the cell
Which cell?
Am I changing something wrong
Probably. Can't know for sure without seeing the formula
I have to go to column "T"
Should be no problem.

Regards,
Fred


"Norm" wrote in message
...

"JLatham" wrote:
When I try to go across it works for 1, 2, 3, for colums A,B,C
I get a #REF in the cell
Am I changing something wrong
I have to go to column "T"

It sounds to me like a VLOOKUP will do the job for you: Assuming that
your
list on Sheet2 starts at A2, something like this:
=VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False)
should work. The ",2," in that formula would return values from column
B,
",3," would return values from the 3rd column of the table (column C),
etc.

Just be sure that C3 and the dates in Sheet2 are of the same data type:
either real dates or text entries.

To guard against #N/A errors being displayed when the date you enter in
C3
does not match any entry on Sheet2, wrap the formula this way:

=IF(ISNA(VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False) ),"",VLOOKUP($C$3,'Sheet2!$A$2:$E$100,2,False))

(all on one line in Excel, of course).

"Norm" wrote:

I have to pull data from one sheet to another depending on the date
entered
on the first sheet
I want to enter todays date in C3 of sheet 1
I want the data in the second sheet from the row with the same date
Sheet 1:

REPORT DATE 4/11/2010

Genesis KPI's UOM
OUTBOUND DATA DATA
RECEIVING

Sheet 2

11-Apr 1 9 0 6
12-Apr

Is this a VLOOKUP?
Thnaks