vlookup multiple values

M

midra

New member
Joined
Aug 10, 2013
Messages
2
Reaction score
0
Points
0
Please look at my attachment. I am desparate to get this formula. In column C I need values from Q matching B (location). Please help.
 

Attachments

  • ST%20MASTER%20NEW(1)(1).xlsx
    301.3 KB · Views: 22
Last edited:
Try this array formula

=IFERROR(INDEX($Q$2:$Q$14,SMALL(IF($P$2:$P$14=$B3,ROW($P$2:$P$14)),COUNTIF($B$3:$B3,$B3))-1),"EMPTY LOCATION")
 
You must log in or register to reply here.
Back
Top