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 you have multiple lookup values
Solved by V. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 25/09/2018 - 02:07
Hi.. Welcome to Got It Pro
Excelchat Expert 25/09/2018 - 02:08
I see that your question is about multiple lookup values..
Excelchat Expert 25/09/2018 - 02:08
I can help you with that problem
Excelchat Expert 25/09/2018 - 02:08
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows
Excelchat Expert 25/09/2018 - 02:11
You said you need help with lookup when you have multiple lookup values
Excelchat Expert 25/09/2018 - 02:11
but I could not response from you.. I will provide solution based on your problem description.
Excelchat Expert 25/09/2018 - 02:13
I will provide example in preview window..
Excelchat Expert 25/09/2018 - 02:17
You can use Index function with Small function to solve this problem..
Excelchat Expert 25/09/2018 - 02:17
ask you can see in the preview window..
Excelchat Expert 25/09/2018 - 02:18
all multiple values with same condition will display
Excelchat Expert 25/09/2018 - 02:18
INDEX(B$2:B$7,SMALL(if($A$2:$A$7=$F$2,row($A$2:$A$7)-1),row(A1))
Excelchat Expert 25/09/2018 - 02:19
This is the formula
Excelchat Expert 25/09/2018 - 02:19
Index function will return value based on small value..
Excelchat Expert 25/09/2018 - 02:20
do you have any other questions?
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.