lbalceda/gist:6167203

Last active December 20, 2015 17:18

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/lbalceda/6167203.js"></script>
Save lbalceda/6167203 to your computer and use it in GitHub Desktop.

Download ZIP

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

Raw

gistfile1.txt

=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