Hello,
I need a quick fix to tidy up a vlookup function. below is the regular function:
=vlookup(B3,scrap!$B$4:$F$4,5,False)
It works fine and such but is there an IF function I can put in so that if there is no value to return it returns 0 insteas of #N/A
Thank you in advance.
I need a quick fix to tidy up a vlookup function. below is the regular function:
=vlookup(B3,scrap!$B$4:$F$4,5,False)
It works fine and such but is there an IF function I can put in so that if there is no value to return it returns 0 insteas of #N/A
Thank you in advance.