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
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