**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?