MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vlookup on different columns...


Posted by mabaud on December 31, 2000 12:29 AM

Consider the following exemple
Column I have one column A with figures, a second column B with other figures and a third one C with text.
I am trying to the row that matches the following condition:
find a value (exemple "No25") in a table where "No" is in one column and 25 in an other one.
I used the following formula :
=VLOOKUP("No25";E8:E9&F8:F9;2;FALSE)


Posted by mabaud on December 31, 2000 12:35 AM

sorry, mistake. Here is the right one....

Consider the following exemple
Column A
111
112
112
Column B
1
2
4
Column C
here
there
where
I would like to find the row that matches the following condition: =1122(a2&a2) and return "there".
I tried =vlookup(expr1&expr2;a1:a3&b1:b3;2;FALSE)
but it is not working.
thanks for your help
mabaud

Posted by Aladin Akyurek on December 31, 2000 2:39 AM

Re: sorry, mistake. Here is the right one....

control+shift-enter the following array formula:

=INDEX(C:C,MATCH(A2&B2,$A$1:$A$3&$B$1:$B$3,0))

Aladin