Return Column Number Based on Two Criterias

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;

Please Login or Register  to view this content.

Thanks a lot in advance for your help.

Regards

tac

Hi Sir;

Thanks a lot for the prompt answer. Please find here attached the sample workbook. Hope it's the way you've asked.

Regards;

tac

Dear Sir bebo;

Works like a charm! Thanks a lot for the help, really appreciated. You're great

Regards;

tac

Thanks a lot for your time and answer AZ-XL.

Solution you've offered gives circular reference. I think because of the usage of "E12". bebo's solution works.

Thanks a lot anyway. Appreciate it.

Regards;

tac