Thread: Vlookup to find first date of number of dates and return matching value

hi
supposing your list of balances in sheet1 - col A&B
date is in sheet2 col A (could be in another workbook)
in sheet 2 col B write this code:

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

then you can drag down it down
hopefully that will help

Originally Posted by noexcel=badwork

hi
supposing your list of balances in sheet1 - col A&B
date is in sheet2 col A (could be in another workbook)
in sheet 2 col B write this code:

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

then you can drag down it down
hopefully that will help

t

Hi I have tried that and the A:B bit doesn't work for me..so I've just put in the actuaI range, and I've actually found that when I put FALSE at the end Excel will return the first balance for the matching date and if I omit false...it will return the matching balance for the last date.

Thanks for your help!

Originally Posted by abalserv_G

then go to Balances and find the FIRST balance it finds there and return it i.e. the answer should be 23000.
Anne

that's what you want, the first balance, and by this formula it will look for the first
balacne, or you want something else, please explain more or attach sample file
thanks and regards,

Originally Posted by noexcel=badwork

that's what you want, the first balance, and by this formula it will look for the first
balacne, or you want something else, please explain more or attach sample file
thanks and regards,

This works for me...thank you for your help...