Maybe

=INDEX(F1:F20,MATCH(A1,G1:G20,0),1)

Mike

"Paul" wrote:

Hi there,

Many months ago I found a function (I'm sure it was on this site) for a
"backwards" vlookup ie Right to Left instead of Left to Right.
If anyone knows where it is can you point me in the right direction please.

Many thanks

Paul