(Solved) – How do you match a name to values in multiple columns Excel VBA?


How do you match the names to the event number if event numbers are in multiple columns on a separate sheet in excel VBA? I need the names of the athletes based on event number.


enter image description here

Body Num,Preferred Name,Last Name, Gender, Age Group,Age,USA #, USA Club,LSC 5K Event, 5K Wave, 3K Event, 3K Wave, 1K Event, 1K Wave, 1/2K Event, 1/2K Wave,
all have separate columns

Desired output

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *