ExcelBanter - Vlookup function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup function (https://www.excelbanter.com/excel-programming/418477-vlookup-function.html)

Paul

Vlookup function

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

Mike H

Vlookup function

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

Paul

Vlookup function

Uber thanks, works a treat

Paul

"Mike H" wrote:

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

All times are GMT +1. The time now is 03:45 AM.