Forum Discussion
Vlookup
Dear All,
I would like some help with Vlookup
What I need to do is look at 2 seperate list of dates. If the dates are the same from each worksheet then I need to return to a specific cell contents of another cell.
Meaning the following.
i look at (B38:B84) on one sheet, I look at 'Incoming Finance'!B5:B348) on another sheet if the contents (dates) are the same then I want to copy the contents of incoming finance cell E5:E348 to (D38:D84)
In english this means if the two dates are the same copy the values from a horizontal offset cell to another cell in a range of cells.
More detailed is if worksheet "Income Tracking" cell B38 Date is the same as any cell within the range E5:E348 on worksheet Incoming Finance. then copy the contents of the cell (HXXX) from income tracking" worksheet to cell FXXX on "Income tracking" worksheet where cell FXXX is the same date as the the two compared dates.
Best Regards
Vonryan
- A simple VLOOKUP like this in D38 is all you need:
=VLOOKUP(B38,
'Incoming Finance'!B$5:M$348,
5,0)
Note that the col_index_num argument of 5 is hard-coded because there is no identical column label in the Incoming Finance Sheet against which the corresponding column label in the Income Tracking Schedule Sheet may be matched.
17 Replies
- I suggest that you attach your sample file so that I can visualize your desired results.
hI,
For a further explanation in the file you will see Incoming Finance worksheet with dates in column B.
You will also see on worksheet Income Tracking Schedule (US$) dates in column B. these are the Saturdays of each week of the project.
So for every Saturday on the Income Tracking Schedule (US$) i would like to retrieve the Running Total (US$): value in Column F on the incoming Finance worksheet for tat Saturday and place it in the Income Tracking Schedule (US$) column D for that particular Saturday.
Hope you can still help.
Regards
Ian
