Return Multiple Values For Lookup Value


Excel Course : The Ultimate Excel Programmer Course

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

Sample Data
Multiple Values with Vlookup

Output
Output Snapshot

Formula

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
Coursera Data Science

Excel Tutorials : 100 Excel Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

0 Response to "Return Multiple Values For Lookup Value"

Post a Comment

Next → ← Prev