Lookup a row meeting several criterias

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

I have a worksheet containing three columns:

Name
ID#
Phone number

In another sheet I have two cells where I want to enter the name and
the ID#. Then I want to display the phone number but I do not know how
to lookup this in my data range.

Best regards
Ken
 
Kenneth said:
I have a worksheet containing three columns:

Name
ID#
Phone number

In another sheet I have two cells where I want to enter the name and
the ID#. Then I want to display the phone number but I do not know how
to lookup this in my data range.

Best regards
Ken
Click to expand...

Will your ID numbers be unique? If so, you don't need to enter the name as
well - just enter the ID number and look up both name and phone number.
Getting the name might well need a 'left lookup'. There's lots of useful
information here:
http://www.cpearson.com/excel/lookups.htm#LeftLookup
 
Back
Top