Hello all

Looking for some help on a formula

Using the following table below i would like to find the corresponding color that is associated with a certain set of criterias.

For example if the question was for WK3 which color is the number 1 color.

I was using index/match however i could find a way for the match function to find the corresponding column based on "wk3" as the criteria

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

Any help would be appreciated
Thanks
James