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