Hi Redbaby,
If I understand you correctly you want to display nothing instead of #value.
Try this:
=IF(OR(PaymentDetails!$B22="",ISERROR(VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))=TRUE),"",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22
Best regards,
Trowa
Thank you for your time and effort to help.
=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22
Yes the 4th column of AppMember range is a number and the value E22 is also a number but the problem I think is the fact that column D of PaymentDetails is vlookup.
That is to say column B of PaymentDetails is validated members name to vlookup members monthly savings of say 10,000 in column D from another sheet, now if the member pays for say two months the formula will multiply the 10,000 by column E(E22) and return 20,000 in column D and this is correct but all the empty cells are returning the error #value.
Thanks once more, I hope I'm able to make you understand.