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
sheets.support@gotitapp.co
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
=index($C$1:$C$10,match(E3&F3,index($A$1:$A$10&$B$1:$B$10),0))
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.
