ExcelBanter - Vlookup formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup formula (https://www.excelbanter.com/excel-discussion-misc-queries/68947-vlookup-formula.html)

Moy Emrick

Vlookup formula

How do I add several $ amounts using the same vlookup reference like "data?"
Is there a way to add a sum formula in the field?

JMB

Vlookup formula

It sounds like you may need SUMIF (check excel's help) or SUMPRODUCT (a good
read on SUMPRODUCT can be found at the following link)

http://xldynamic.com/source/xld.SUMPRODUCT.html

"Moy Emrick" wrote:

How do I add several $ amounts using the same vlookup reference like "data?"
Is there a way to add a sum formula in the field?

All times are GMT +1. The time now is 11:01 PM.