Formula: Tidy up Vlookup results

Thorcorp

New member
Joined
May 26, 2011
Messages
6
Reaction score
0
Points
0
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.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=IF(ISNA(VLOOKUP(B3,scrap!$B$4:$F$4,5,False)),0,VLOOKUP(B3,scrap!$B$4:$F$4,5,False))

or if you have Excel 2007/2010

=IFERROR(VLOOKUP(B3,scrap!$B$4:$F$4,5,False),0)
 
Top