Hi,
Does anyone know how to get rid of the #N/A if the formula is not looking for current info.
I would like the cell to equal Zero if nothing is happening.
=VLOOKUP(F12,'Labour Standards'!$I$7:$L$19,4,FALSE)
Thanks
hello
try
=IF(ISNA(VLOOKUP(F12,'Labour Standards'!$I$7:$L$19,4,FALSE)),0)
Contributors to this forum do not get paid. They give their valuable time to help you solve your problem. That's why feel free to CLICK their STARicon to say thank you -even the given idea/solution didn't really solve your queries. The time given to you deserves a small gratitude anyway.
Dare to give a pencil to a child. http://www.blackpencilproject.org/
Hi,
The problem i'm having is that the formula now show false when the cell is active.
=IF(ISERROR(VLOOKUP(F12,'Labour Standards'!$I$7:$L$19,4,FALSE)),0,VLOOKUP(F12,'Labour Standards'!$I$7:$L$19,4,FALSE))
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks