Vlookup to return cell above

[danmolesworth]

Hi all,

I'm using =VLOOKUP(L6,P5:Y9,10,FALSE) to find the cell I want, however I also need a formula to return the cell above too.

Is there anything i can do?

[Pete_UK]

Use INDEX and MATCH instead:

=IFERROR(INDEX(Y5:Y9,MATCH(L6,P5:P9,0)-1),"not found")

Hope this helps.

Pete