"Harlan Grove" wrote in message
...
"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.

That's how I learn!

--
Biff
Microsoft Excel MVP