vlookup question

Posted by Andonny on July 09, 2001 12:11 AM

Hi,
I have been wondering if the following is possible.

=VLOOKUP(E3,$C$1:$D$10000,1,FALSE)
In my case I have E3 equals a data in D column and what I would like to return is whats in C column.

Your help is very much appreciated
Andonny

Posted by Aladin Akyurek on July 09, 2001 12:16 AM

=INDEX($C$1:$C$1000,MATCH(E3,$D$1:$D$1000,0))

Aladin