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