| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
