K
Karen Smith
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)))
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)))