This tutorial explains how to get multiple values for a single lookup value.
Sample Data
Output
Sample Data
![]() |
Multiple Values with Vlookup |
Output
![]() |
Output Snapshot |
Formula
Enter the following formula in G9 and paste it down and to the right
B$3:B$7 - Lookup column
F9 - Lookup value
=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
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!
ReplyDelete