|
lookup
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. |
lookup
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 |
lookup
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. |
lookup
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. |
lookup
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. |
lookup
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. |
| All times are GMT +1. The time now is 02:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com