VBA Add If To Vlookup

[jo15765]

I am using this formula as a Vlookup in VBA - I need to add an if statement to it so that if the value returned is 0 or #NA then leave the cell blank or "" whatever the vba equivelant is

This is my current formula

Please Login or Register  to view this content.

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[jo15765]

YasserKhalil,

That will remove the #NA - but it will still pull over the value if it is a 0. I also want to show "" in the cell if the value is 0

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

VBA Example:

Please Login or Register  to view this content.