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.
Try this
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
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
Last edited by jeffreybrown; 03-29-2017 at 06:48 PM. Reason: Removed full quote which is just clutter!
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
VBA Example:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks