Return Multiple Values For Lookup Value

This tutorial explains how to get multiple values for a single lookup value.

Sample Data
Multiple Values with Vlookup

Output Snapshot


Enter the following formula in G9 and paste it down and to the right
=INDEX(C$3:C$7, SMALL(INDEX(($F$9=$B$3:$B$7)*(MATCH(ROW($B$3:$B$7), ROW($B$3:$B$7)))+($F$9<>$B$3:$B$7)*1048577, 0, 0), ROW(A1)))
C$3:C$7 - Desired column you want the formula to return
B$3:B$7 - Lookup column
F9 - Lookup value
Related Posts
About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 8 years of experience in data science. During his tenure, he has worked with global clients in various domains like Banking, Insurance, Telecom and Human Resource.

1 Response to "Return Multiple Values For Lookup Value"
  1. Deepanshu, I just implemented learnings from 4-5 of your articles to automate a few critical reports! Easily saved a minimum of 20 minutes a day with these changes! You're the man!


Next → ← Prev
Love this Post? Spread the Word!