Hi All;

I'm stuck again. What I'm trying to do is to write a formula which will return column number of a specific value by matching two criteria.

On Sheet2 I have employee name and their test results next to them (C12:D93)

On Sheet1 I have their names and the results of their 5 tests (G12:L62)

Now, what I need to see on Sheet2 E12 is the result in cell D12 belongs to which test. I hope I was able to describe it sufficiently.

I've tried VLOOKUP, INDEX and MATCH with no success and I'm totally lost now.

My last try was the following with no success;

=INDEX('Tests'!$G$12:$L$12,MATCH(D12(INDEX('Tests'!$G$13:$L$62,MATCH(C12,'Tests'!$G$13:$G$62,0),0)),INDEX('Tests'!$G$13:$L$62,MATCH(C12,'Tests'!$G$13:$G$62,0),0),0))
Thanks a lot in advance for your help.

Regards

tac