Last active
December 20, 2015 17:18
-
-
Save lbalceda/6167203 to your computer and use it in GitHub Desktop.
Excel: Ignore " #N/A " output by combining IFERROR with VLOOKUP to map a missing / nonmatching value to 0 . Includes sheet name in VLOOKUP for cross sheet portability. Don't usually work with excel but my cousin asked me for 'excel help' #family
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =IFERROR(VLOOKUP(F2,'Week 1 '!$R$1:$S$4,2,FALSE),0)+IFERROR(VLOOKUP(G2,'Week 1 '!$R$1:$S$4,2,FALSE),0)+IFERROR(VLOOKUP(H2,'Week 1 '!$R$1:$S$4,2,FALSE),0)+IFERROR(VLOOKUP(I2,'Week 1 '!$R$1:$S$4,2,FALSE),0)+IFERROR(VLOOKUP(J2,'Week 1 '!$R$1:$S$4,2,FALSE),0) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment