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

Excel Tutorials : 100 Excel Tutorials

About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has over 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like banking, Telecom, HR and Health Insurance.

While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*
Related Posts:
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