"T. Valko" wrote...
"Harlan Grove" wrote in message
....
=ADDRESS(MATCH(MIN(IF((LEFT('PDAs Report'!G3:G1000,3)="BJ ")
*('PDAs Report'!H3:H1000=C1),'PDAs Report'!J3:J1000)),
'PDAs Report'!J3:J1000,0)+2,10,4)
....
I didn't try the first formula but the second formula doesn't account for
duplicate MIN's not meeting the conditions.

So you don't fix formulas? That's OK. I'll continue to fix yours.

=ADDRESS(MATCH(MIN(IF((LEFT('PDAs Report'!G3:G1000,3)="BJ ")
*('PDAs Report'!H3:H1000=C1),'PDAs Report'!J3:J1000)),
IF((LEFT('PDAs Report'!G3:G1000,3)="BJ ")*('PDAs Report'!H3:H1000=C1),
'PDAs Report'!J3:J1000),0)+2,10,4)