Mar 18 2021 08:57 AM
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.
Mar 18 2021 09:16 AM
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.