MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP FUNCTION


Posted by Chuck L. on February 02, 2001 1:29 PM

Anyone know how can I lookup 'two different' lookup_values on the same row within a table_array. ie:name and ssn?


Posted by Mark W. on February 02, 2001 1:41 PM

Suppose you cells A1:C3 contain:

{"ID","NAME","SSN"
;"1005","Jerry Garcia","444-33-7777"
;"2005","Jethro Tull","123-55-7812"}

Select any two cells on a row, and enter the
formula =VLOOKUP("1005",$A$1:$C$3,{2,3},0) as
a single array formula (using Shift+Ctrl+Enter).
When viewed on the formula bar the formula will
look like:

{=VLOOKUP("1005",$A$1:$C$3,{2,3},0)}

Posted by Celia on February 02, 2001 4:07 PM


If you want to look-up 2 values as opposed to returning 2 values, then using Mark's data :-
=INDEX($C$1:$C$3,MATCH(1005&"JG",$A$1:A3&$B$1:$B$3,0))
Enter by Ctrl+Shift+Enter
Celia

Posted by Stephen Giles on February 05, 2001 5:33 AM

Ah, Jethro Tull - did you know that Clive Bunker, ex Jethro Tull, is now gigging in the UK with Jerry Donaghue, ex Fairport - now that must be some band!!!!