Hi,
I've been trying to apply a SUMIFS function using INDEX and MATCH as seen in this file.
Basically, I have a certain type, and I want to fill in Products 1-5 based on the Type.
So far, all I'm getting is "0".
Any help is appreciated, thanks!
Hi,
I've been trying to apply a SUMIFS function using INDEX and MATCH as seen in this file.
Basically, I have a certain type, and I want to fill in Products 1-5 based on the Type.
So far, all I'm getting is "0".
Any help is appreciated, thanks!
Here you go...
Copy that formula down through B7.Please Login or Register to view this content.
Does that help?
It does help quite a bit, at least for the text...but how do I get it to include both text and numbers? I will post an updated file in just a minute to show what I mean.
This formula works for text and numbers greater than zero:
Copy that formula down through B7.Please Login or Register to view this content.
Does that help?
Perhaps try
=INDEX($B$10:$F$14,MATCH($B$1,$A$10:$A$14,0),MATCH($A3,$B$9:$F$9,0))&""
Audere est facere
Nice touch...I didn't even think to just tack on an empty string.
They both work perfectly...thanks so much to you both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks