Dear Tom,

I solved my problem using a slightly diff formula:

=IF( COUNTIF('US HRC Prices'!$A$3:$D$280,E1),VLOOKUP(E1,'US HRC Prices'!$A$3:$D$280,4,0),"Thank you for your help though.

Cheers,

DLB