=IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&B11&"-"&C11,'Writing
Charges (2)'!F3:G237,2,0)*I11)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Karen Smith" wrote in message
...
I'm having trouble getting this formula to work, what am I doing wrong?

=IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&b11&"-"&c11,'Writing
Charges (2)'!f3:g237),2,0)*I11)