SUM of VLOOKUP Value from Different Sheets

Digit4L

New Member
Joined
Feb 28, 2019
Messages
2
Dear All,

I would like to SUM the VLOOKUP Value from Different Sheets..

I don't want to use SUMIF or SUM, because I have 2000+ Product Rows of Data and 40 Columns, If I include any new Product in Sheet 1 or Sheet 2 and Sort the data based on the Category, Main Sheet Data will give me bad result.

Example :

=VLOOKUP(E6,SHEET1!$E$5:$AM$9,11,FALSE) + VLOOKUP(E6,SHEET2!$E$5:$AM$9,11,FALSE) + VLOOKUP(E6,SHEET3!$E$5:$AM$9,11,FALSE) + VLOOKUP(E6,SHEET4!$E$5:$AM$9,11,FALSE) + + VLOOKUP(E6,SHEET5!$E$5:$AM$9,11,FALSE)

Looking for your Help,
Thanks alot
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
Let A1:A5 (or some other range) house the sheet names SHEET1, SHEET2, etc.

Now try:

=SUMPRODUCT(SUMIFS(INDIRECT("'"&$A$1:$A$5&"'!O5:O9"),INDIRECT("'"&$A$1:$A$5&"'!E5:E9"),E6))
 

Watch MrExcel Video

Forum statistics

Threads
1,108,790
Messages
5,524,893
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top