View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] stephen.h.dow@gmail.com is offline
external usenet poster
 
Posts: 6
Default MATCH multiple values

If headers are in row 1 and data (names) start in A2 and badges start
in E2, then this should work:

Lookup name in K2
Lookup first badge in L2: =VLOOKUP(K2,$A$2:$E$12,5,0)
Lookup second badge in M2: =IF(OFFSET($A$2,MATCH(K2,$A$2:$A$12,0),
0)=K2,OFFSET($A$2,MATCH(K2,$A$2:$A$12,0),4),"No badge")
Lookup third badge in N2: =IF(OFFSET($A$2,MATCH(K2,$A$2:$A
$12,0)+1,0)=K2,OFFSET($A$2,MATCH(K2,$A$2:$A$12,0)+ 1,4),"No badge")

Hope that helps..