I am Stuck with a date related problem using Lookup. I have got data in Sheet 1 like this:
Item Date Qty
A 10-10-08 5unit
B 12-11-08 4unit
I have another Sheet with details of all transaction related to items . something like below:
Item Document Date Qty
A GRN-001 05-08-08 10unit
A GRN-081 19-09-08 2unit
A GRN-085 21-10-08 12unit
A GRN-090 04-11-08 11unit
B GRN-021 15-08-08 8unit
B GRN-088 21-09-08 5unit
Now the challange for me is to look for 1st sheet item into the 2nd sheet data and get the document no. and date which are immediately before the corresponding date of the item in 1st sheet.
In other words, for item "A" in 1st sheet ,I have to get document no. and date from 2nd sheet which should be GRN-081 and 19-09-08
I tried working with vlookup and date function but in vain.
Plz suggest me some solution how to do this.
Thanks
Shabbir
Bookmarks