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.

try this one and see if it works

=Vlookup("A",A1:B4,2,FALSE)


--
Portuga
------------------------------------------------------------------------
Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385
View this thread: http://www.excelforum.com/showthread...hreadid=545915

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.

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.

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.

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


"Ken Hudson" wrote:

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.