sum with new vlookup sheet reference
I have this formula copied down a column: =vlookup(A1,ReferenceAnotherSheet,3). The first row bring back the correct number value. The other rows are bringing back a #nomatch.
Also, I want the cell to return the total of all cells in column 3 that contain the cell referenced in A1. I know I need to use sum or sumif, but can't figure it out. Thanks.
Help Article Resources
Check out the Formula Handbook template!