index and match

[Viperlx]

I am having an issue trying to index and match multiple columns at once.

=INDEX(Players!B:B,MATCH('Main Sheet'!B2,Players!A:A,0))

The formula above works great for one column but when it comes to multiple it doesn't work.

=INDEX(Players!B:B,Players!F:F,Players!H:H,Players!J:J,Players!L:L,Players!D:D,MATCH('Main Sheet'!B2,Players!A:A,Players!C:C,Players!E:E,Players!G:G,Players!K:K,Players,I:I,0))

I tried this but it came back with too many arguments. How can I fix it?

 

[Viperlx]

Bump