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?