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


--
koala
------------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...o&userid=12953
View this thread: http://www.excelforum.com/showthread...hreadid=386404

try Chip Pearsons web site for a solution


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


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=386404

Thanks Ruthki,

That site is excellent and has exactly what I need.

You have saved me heaps of hours of painful work

cheers
Koala


--
koala
------------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...o&userid=12953
View this thread: http://www.excelforum.com/showthread...hreadid=386404

Hi,

Check up the Index function from the Hekpo menu.

Regards,

Ashish Mathur

"koala" wrote:


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


--
koala
------------------------------------------------------------------------
koala's Profile: http://www.excelforum.com/member.php...o&userid=12953
View this thread: http://www.excelforum.com/showthread...hreadid=386404