Index match help needed

If you are using index and match for this data. Your data is not suitable.

But if this is your data and your request is to find which color is rank first in week 3, you will require some other formula.

To arrange the data to be suitable for index and match. It look like this

1 Wk1 Wk2 Wk3
1 Red Blue Yellow
2 Blue Yellow Green
3 Yellow Green Black
4 Green Black White
5 Black White Red
6 White Red Blue

If you are unable to rearrange your data, the formula that I could provide would be slightly complicated than index and match.

hi James, try:
=INDEX(D2:D7,MATCH(1,INDEX((A2:A7,B2:B7,C2:C7),,,MATCH("Wk3",A1:C1,0)),0))

the one in red font can be referred to a cell reference too

Edit: or another like
=INDEX(D2:D7,MATCH(1,INDEX(A2:C7,,MATCH("wk1",A1:C1,0)),0))

try :
=Offset(a1,match("1",c2:c7,0),match("Wk3",a1:c1,0)-1))

change ranges and references to actual

Hope this helps

Edit-
or
=Index(A1:C7,match("1",c1:c7,0),match("Wk3",a1:c1,0))