Hello guys,
I want to do a lookup with multiple criteria
In C34:AB34 are the Months, In B30 is the lookup value for Month
In B36:B56 are the Company Names, In C30 to X30 lookup values for Company Name
In C35:AB35 are the Columns for Billing and Collection, in B31 is the lookup value for Billing, and B32 is the lookup value for collection.
Billing criteria returns the right values. For collection, however it is not and I wonder what is wrong with it?
The formula I used is =SUMPRODUCT(($B$36:$B$56=C$30)*($C$35:$AB$35=$B32)*($C$34:$AB$34=$B$30),$C$36:$AB$56)
Anyone got better ideas?
I want to do a lookup with multiple criteria
In C34:AB34 are the Months, In B30 is the lookup value for Month
In B36:B56 are the Company Names, In C30 to X30 lookup values for Company Name
In C35:AB35 are the Columns for Billing and Collection, in B31 is the lookup value for Billing, and B32 is the lookup value for collection.
Billing criteria returns the right values. For collection, however it is not and I wonder what is wrong with it?
The formula I used is =SUMPRODUCT(($B$36:$B$56=C$30)*($C$35:$AB$35=$B32)*($C$34:$AB$34=$B$30),$C$36:$AB$56)
Anyone got better ideas?