Wondering if anyone can help with this. I have a table with athletics events down column A and Club names across the top. Names will be filled in against events and clubs. I then wish to pull names into from the table to the actual event once run. However clubs run under one of two numbers eg 12 & 112. I have tried the formula below which isn't working which looks for the event in Col A and then tries to MATCH either of the club numbers to give the corresponding column number. It works if the correct number is in the first array but not the second. Image attached & File attached.

=IFERROR(VLOOKUP($I$6,$A$2:$G$33,MATCH(J8,$A$2:$G$2),FALSE),VLOOKUP($I$6,$A$2:$G$33,MATCH(J8,$A$3:$G$3),FALSE))

Any help gratefully received

GeeDee