Can Vlookup check a cell to the left?

K

koala

I have a dataset which has the "trigger" value in column "E".

The problem I have is that I want it to return the value of column
"D".

This is not possible using Vlookup as Colum "E" is 1, "F" is 2 etc. I
have tried referencing column "D" as -1, but this isnt allowed.

Can anyone suggest how I can achieve this.

Thanks in advance
Koala
 
K

koala

Thanks Ruthki,

That site is excellent and has exactly what I need.

You have saved me heaps of hours of painful work

cheers
Koala
 
Top