I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks up Austin to a corresponding value of 1. I also require other matches to locate backups as shown below. example, it looks up Austin.
Employee Name Austin Janet Rita John Jenson Skill level 1 2 3 3 1
SME SME 1 SME 1 backup SME 2 SME 2 backup SME 3 SME 3 backup Austin Jenson Janet NA Rita john