Excel - LOOKUP Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

need help with lookup when i have multiple lookup values. Plz help me
Solved by V. U. in 58 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/10/2018 - 12:42
Hello, I understand that you need help with a lookup that has multiple lookup criteria, right?
Excelchat Expert 08/10/2018 - 12:43
Are you there?
Excelchat Expert 08/10/2018 - 12:44
If you can read this but are unable to reply please try to refresh your browser.
Excelchat Expert 08/10/2018 - 12:44
Otherwise, you can try to send a message using the sheet to the right.
Excelchat Expert 08/10/2018 - 12:44
If those don't work, your network may be partially blocking our platform and if that's the case I'd have to ask you to please contact our support team so they can help you with the connectivity. Meanwhile I'll be solving your problem based on the information and the sheet you provided.
Excelchat Expert 08/10/2018 - 12:44
Excelchat Expert 08/10/2018 - 12:44
Hopefully this session will still be rated fairly as there's really nothing I can do about the network blockage.
Excelchat Expert 08/10/2018 - 12:47
Please see the SOLUTION to lookup based on multiple lookup values in the SOLUTION Sheet cell G3.
Excelchat Expert 08/10/2018 - 12:47
The formula is
Excelchat Expert 08/10/2018 - 12:47
Excelchat Expert 08/10/2018 - 12:48
This concatenates the ID and Name and then looks it up based on those 2 criteria.
Excelchat Expert 08/10/2018 - 12:48
Here's the file with the solution.
[Uploaded an Excel file]
Excelchat Expert 08/10/2018 - 12:50
If you comeback and read this and you need help in applying the above technique to your file, please contact our support team so they can help you with the network issue to our platform and get connected to an Expert. I will be staying for a while to give you enough time try and communicate with us.
Excelchat Expert 08/10/2018 - 12:50
I sincerely hope that this session is rated fairly.
Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc