| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Problem: VLookup
Hi there, When using Vlookup, is it possible to use a lookup value in 2 adjacent cells i.e the lookup values I am using are people's surnames, but where people have the same surname vlookup does not work. Therefore, I want to be able to use a1:b1 as a lookup value that will contain the forename in a1 and the surname in b1 - howeverm this does not seem to work?? Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=314831 |
|
#2
|
|||
|
|||
|
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER): =INDEX(C1:C100,MATCH(1,(A1:A100="surname")*(B1:B10 0="firstname"),0)) "andyp161" wrote: Hi there, When using Vlookup, is it possible to use a lookup value in 2 adjacent cells i.e the lookup values I am using are people's surnames, but where people have the same surname vlookup does not work. Therefore, I want to be able to use a1:b1 as a lookup value that will contain the forename in a1 and the surname in b1 - howeverm this does not seem to work?? Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=314831 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel problem with web based spreadsheets | Excel Discussion (Misc queries) | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
| Staring Excel Problem | Excel Discussion (Misc queries) | |||
Linear Mode
