Forum Discussion
Look up across multiple rows
Hi My accounting sales summary returns each invoice individually. As a result I have multiple rows with the same part number but different quantities. Is there a combination of Vlookup plus sum etc… ...
Perhaps PivotTable or SUMIFS() could work. Perhaps you may share small sample file to illustrate how data is structured.