Hi,
1. Just to be sure, the VLOOKUP formula and the data range A1:B4 are in the
same worksheet?
2. If they are, then you probably have an extra space in the cell containing
the A in the look up range. In an empty cell type =LEN(A2). If you get more
than 1 as an answer, you have an extra space or spaces in that cell.
--
Ken Hudson


"Rajula" wrote:

Hi,

I tried both the options.. it gives #N/A...

"Daniel CHEN" wrote:

There are two ways to correct it:
1) Change TRUE to FALSE, like =Vlookup("A",A1:B4,2,FALSE)
OR
2) Change range A1:B4 to A2:B4.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

"Rajula" wrote in message
...
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.