Vlookup #N/A results

%3CLINGO-SUB%20id%3D%22lingo-sub-2220300%22%20slang%3D%22en-US%22%3EVlookup%20%23N%2FA%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2220300%22%20slang%3D%22en-US%22%3E%3CP%3ETrying%20to%20get%20rid%20of%20the%20%23N%2FA%20results%20as%20shown%20on%20tab%20%22Total%20Summary%22%20of%20the%20attached%20file.%26nbsp%3B%20Take%20for%20example%20cell%20d13%20which%20is%20looking%20for%20the%20contents%20of%20cell%20b13%20in%20another%20sheet%2C%20however%20the%20other%20sheet%20does%20not%20have%20that%20user%2C%20so%20I%20want%20d13%20to%20either%20show%20nothing%20or%20zero%20so%20that%20the%20other%20formulas%20will%20still%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%26nbsp%3B%20There%20are%20a%20lot%20of%20great%20helpers%20in%20this%20community.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELarry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2220300%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Trying to get rid of the #N/A results as shown on tab "Total Summary" of the attached file.  Take for example cell d13 which is looking for the contents of cell b13 in another sheet, however the other sheet does not have that user, so I want d13 to either show nothing or zero so that the other formulas will still work.

 

Thanks in advance!  There are a lot of great helpers in this community.

 

Larry.

1 Reply

@Larry1921 

For example, change the formula in D6 to

=IFERROR(VLOOKUP(B6,'2021-Loads'!$B$93:'2021-Loads'!$J$113,5,FALSE),"")

then fill down to D34.

Similarly, change the formula in E6 to

=IFERROR(VLOOKUP($B6,'2020-Loads'!$B$92:'2020-Loads'!$J$106,5,FALSE),"")

and fill down.

Etc.