lookup

Giganews Newsgroups
Subject: lookup
Posted by:  Rajula
Date: Fri, 26 May 2006

I hope i can explain the problem well.

For Eg in a seperate sheet if the name is A, then it should lookup for the
name in the Range A1:B4 and return the value Architect.

What is the best formula for this. I wrote a formula like this
=Vlookup("A",A1:B4,2,TRUE) .. it just retuns the name of the colum TYPE
instead of Architect.

Eg
NAME    TYPE
A    Architect
B    Buss Ana
C    Developer
D    Tester

I did lot of trial and error using Index, Match etc etc.. nothing seems to
be helping me.

Replies