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.