IF VLOOKUP
=IF(C8<"yes","",IF(ISNA(VLOOKUP(A8&"-"&F8&"-"&G8,'Writing
Charges'!$D$3:$E$60,2,0)),"",VLOOKUP(A8&"-"&F8&"-"&G8,'Writing
Charges'!$D$3:$E$60,2,0)*I8))
--
Regards,
Peo Sjoblom
"Karen Smith" wrote in message
...
I've got a formula (below) that isn't working, I'm sure its something I
did
wrong, but I'm not sure what. If C8=yes the formula should do a vlookup
if
C8=no, it should do nothing. Can someone help me fix my formula?
=IF(ISERROR(c8="yes",(VLOOKUP(A8&"-"&F8&"-"&G8,'Writing
Charges'!$D$3:$E$60,2,0)*I8),"",(VLOOKUP(A8&"-"&F8&"-"&G8,'Writing
Charges'!$D$3:$E$60,2,0)*I8)))
|