Hi I am trying to do a 2 WAY INDEX/MATCH FORMULA and return multiple matched columns and sum them up.
The following code works. I was wondering if there is a better way to do it? Also if I decide to Add SalesMonth3, Can it automatically adjust the area to sum up?
Please Login or Register to view this content.
I'm using the following named ranges:
STYLE =REPORT!$F$6:INDEX(REPORT!$F:$F,COUNTA(REPORT!$F:$F)+5)
SALES =REPORT!$4:$4
SalesMonth1 =InfoSheet!$A$12 (FEB)
SalesMonth2 =InfoSheet!$A$13 (MAR)
I included a sample book.
Thank You!
Bookmarks