Results of cell depending on column

Hi,

This should be a simple one but for some reason I can't get my head round what I'm doing.

I've attached the spread sheet as an example.

What I want to do is populate Cell O with a code (Codes are shown on the second tab) depending on which column the value is in.

For example for row 2. the code in column O would be 07-005, and the code for row 3 would be 01-007

HELP!

you can type in cell O2
=VLOOKUP(OFFSET(INDEX(C2:L2,1,MATCH(MAX(C2:L2),C2:L2,1)),-ROW()+1,0),Sheet2!$A$1:$B$10,2,0) and drag down

That is perfect! Been racking my brains all morning!

Thank you

Hi there,

what about such an approach:

=INDEX(Sheet2!$B$1:$B$10;MATCH(INDEX($C$1:$M$1;MATCH(N2;$C2:$M2;0));Sheet2!$A$1:$A$10;0)) and drag it down

of course, it is a bit confusing, too.... but, I think under the bottom line it is the more simple way to do it since I just use index() and match() only....

kind regards from Hamburg

Henning