Return the value above the cell found from vlookup?

[joshnathan]

Hi i have a very simplistic vlookup that returns a date all i want to do is return the date located in the cell above it but for some reason i just cant work out how to do it. Should i be using something instead of a vlookup?

[FDibbins]

try using indx/match to find what you want, and in the 1st match, use -1 at the end

[joshnathan]

Good Point, got it working thanks.

=INDEX(BW2:BW171,(MATCH(U5,BW2:BW171,FALSE)-1),)

[Ron Coderre]

Try this structure:

=INDEX(date_column_range,MATCH(your_date,date_column_range,0)-1)

Does that help?

[FDibbins]

If you will be copying this down (or across) anywhere, you will need to absolute ($) some of those references