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! |
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 |