MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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:

;"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:


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 :-
Enter by Ctrl+Shift+Enter

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