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.
CLEANED INPUT FORMAT
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