Vlookup

[Need Help With Vlookup]

I need vlookup to capture and sum all figures pertaining to the same G/L code
even if there is more than one of the same line item on the data sheet. The
data sheet is separate from the summary sheet which is where I am pulling the
information onto.

 

[JE McGimpsey]

use SUMPRODUCT instead:

SUMPRODUCT(--(A1:A100=<g/l code>),B1:B100)


See

http://www.mcgimpsey.com/excel/doubleneg.htm


for an explanation of the "--"

"Need Help With Vlookup" <Need Help With