Double lookup / match

[Peter1999]

Hi everyone,

I'm looking for a function that will return another (text) value, based on a lookup of a (max) reference. Please see the file attached for a better explanation ;-). Thanks in advance,

Kind regards,

Peter1999

[sweep]

B16 =INDIRECT(CHOOSE(MATCH(MAX(B3:D3),B3:D3,0),"B","C","D")&2) and copy down


C16 =INDIRECT(CHOOSE(MATCH(MAX(F3:H3),F3:H3,0),"F","G","H")&2) and copy down

hth

dave

[NBVC]

See attached

[Peter1999]

Cheers, that works great!