Can Vlookup check a cell to the left?

[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

 

[Ruthki]

try Chip Pearsons web site for a solution


http://www.cpearson.com/excel/lookups.ht

 

[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

 

[Guest]

Hi,

Check up the Index function from the Hekpo menu.

Regards,

Ashish Mathur