FYI: I tried your and Biff's formula and both worked fine (giving identical
answers) on the data you posted. #VALUE suggests (to me) a data problem.

"T. Valko" wrote:

Try this array formula:

=INDEX(DATA!B2:B1000,MATCH(MAX((DATA!G2:G1000=A108 )*DATA!Z2:Z1000),DATA!Z2:Z1000,0))

Biff

"LucyRB" wrote in message
...
Thanks for your prompt reply, Roger. I tried your suggestion, but it
didn't
work. It returned the number from Data!B, row 2 (ie. the very first
number
in Data!B column).