lookup

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.
 
D

Daniel CHEN

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
=================================
 
R

Rajula

Hi,

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

Daniel CHEN said:
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
=================================
 
K

Ken Hudson

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

Rajula

Hi All,

Thanx for all the replies.
I dont know what the problem was..

But i copied columns one by one column into another sheet & inserted the
formula.. And now it works..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top