R
Rajula
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.
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.