Forum Discussion
Solved
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 con...
- 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.
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