Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup across worksheets.
I have the following worksheets:
Reconciliation Allred, B. Hills, C. On the Reconciliation, I want to pull information from the other two worksheets. In cell A2, I've entered the date. I want to use a VLOOKUP to pull information from the other 2 worksheets that coordinate with the date in A2. I found an example of what I thought I wanted my formula to look like but it just puts a 0 in the destination cell (B4). =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) If I have a match on the date of column A on Allred, B. table to cell A2 on the Reconicilation table, than I want the data from Column B (Allred, B. table) that corresponds to the date, entered on the Reconciliation Table Cell B4. Thanks for your time! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup across worksheets.
I am a little confused.
Is this formula is on the Reconciliation sheet: =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) ? If you want to pull data from the other sheet, should it not be =VLOOKUP(A2,'Allred, B'!A$1:F$100,3,0) The 3 indicates the third column of A:F so this is column C. This will pull from a row in C1:C100 into the cell containing the formula. Please come back with a clarification if I am totally screwed up! best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tia" wrote in message ... I have the following worksheets: Reconciliation Allred, B. Hills, C. On the Reconciliation, I want to pull information from the other two worksheets. In cell A2, I've entered the date. I want to use a VLOOKUP to pull information from the other 2 worksheets that coordinate with the date in A2. I found an example of what I thought I wanted my formula to look like but it just puts a 0 in the destination cell (B4). =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) If I have a match on the date of column A on Allred, B. table to cell A2 on the Reconicilation table, than I want the data from Column B (Allred, B. table) that corresponds to the date, entered on the Reconciliation Table Cell B4. Thanks for your time! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup across worksheets.
That works great!!
Is there a limit to the amount of columns you can have Vlookup look at? The formula works great up to 12, then I get a REF error on 13-my formula looks like the following: =VLOOKUP(A2, 'Allred'!A$1:L$100,13,0). "Bernard Liengme" wrote: I am a little confused. Is this formula is on the Reconciliation sheet: =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) ? If you want to pull data from the other sheet, should it not be =VLOOKUP(A2,'Allred, B'!A$1:F$100,3,0) The 3 indicates the third column of A:F so this is column C. This will pull from a row in C1:C100 into the cell containing the formula. Please come back with a clarification if I am totally screwed up! best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tia" wrote in message ... I have the following worksheets: Reconciliation Allred, B. Hills, C. On the Reconciliation, I want to pull information from the other two worksheets. In cell A2, I've entered the date. I want to use a VLOOKUP to pull information from the other 2 worksheets that coordinate with the date in A2. I found an example of what I thought I wanted my formula to look like but it just puts a 0 in the destination cell (B4). =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) If I have a match on the date of column A on Allred, B. table to cell A2 on the Reconicilation table, than I want the data from Column B (Allred, B. table) that corresponds to the date, entered on the Reconciliation Table Cell B4. Thanks for your time! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup across worksheets.
It's because the lookup table has less columns than what you are indexing.
Your table is A1:L100 and if you count from A to (including) L that is only 12 columns so you tell Excel to return values from the 13th column in a table that has only 12 columns. If you would change the lookup table to A1:M100 it would not return a ref error -- Regards, Peo Sjoblom "Tia" wrote in message ... That works great!! Is there a limit to the amount of columns you can have Vlookup look at? The formula works great up to 12, then I get a REF error on 13-my formula looks like the following: =VLOOKUP(A2, 'Allred'!A$1:L$100,13,0). "Bernard Liengme" wrote: I am a little confused. Is this formula is on the Reconciliation sheet: =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) ? If you want to pull data from the other sheet, should it not be =VLOOKUP(A2,'Allred, B'!A$1:F$100,3,0) The 3 indicates the third column of A:F so this is column C. This will pull from a row in C1:C100 into the cell containing the formula. Please come back with a clarification if I am totally screwed up! best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tia" wrote in message ... I have the following worksheets: Reconciliation Allred, B. Hills, C. On the Reconciliation, I want to pull information from the other two worksheets. In cell A2, I've entered the date. I want to use a VLOOKUP to pull information from the other 2 worksheets that coordinate with the date in A2. I found an example of what I thought I wanted my formula to look like but it just puts a 0 in the destination cell (B4). =VLOOKUP(A2,Reconciliation!A$1:F$100,3,0) If I have a match on the date of column A on Allred, B. table to cell A2 on the Reconicilation table, than I want the data from Column B (Allred, B. table) that corresponds to the date, entered on the Reconciliation Table Cell B4. Thanks for your time! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP using two worksheets? | Excel Discussion (Misc queries) | |||
VLOOKUP on multiple worksheets | Excel Discussion (Misc queries) | |||
mulitple worksheets vlookup | Excel Discussion (Misc queries) | |||
Vlookup in different worksheets | Excel Worksheet Functions | |||
Using vlookup on two worksheets | Excel Worksheet Functions |