Bob,

Thanks for the response.

Based on your formula from yesterday, =(IF($E30,"CAD",IF($F30,"USD",IF(ISNUMBER(MATCH( $A3,$A$2:$A2,0)),INDEX($D$2:$D2,MATCH($A3,$A$2:$A2 ,0)),"NOD")))) , following is the outcome, which did not come out correct.

I shortned the category text to CAD, USD & NOD to make it easy for now.

CUSTOMER WORK ORDER# INVOICE # CATEGORY CAD SALES USD SALES USD FX COST OF SALES
ABC 29775 300 USD 100
EFG 25000 320 NOD 200 20
XYZ 26000 NOD 20
PQR 30000 USD
ABC 29775 NOD 40
EFG 27000 USD 150
ABC 29800 NOD 40


SJ
"Bob Phillips" wrote in message ...
How about this

=(IF($E30,"Customer billed in CAD",IF($F30,"Customer billed in USD",
IF(ISNUMBER(MATCH($A3,$A$2:$A2,0)),INDEX($D$2:$D2, MATCH($A3,$A$2:$A2,0)),"Customer not billed"))))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)