I need an INDEX MATCH formula that will match 3 criteria.
In my example that's attached, in cell A7 I cannot get this formula to work.
Please Help...
Thank You!
I need an INDEX MATCH formula that will match 3 criteria.
In my example that's attached, in cell A7 I cannot get this formula to work.
Please Help...
Thank You!
something like this?
=SUMPRODUCT(($A$12:$A$19=$A$3)*($B$12:$B$19=$B$3)*($C$11:$F$11=$C$3)*$C$12:$F$19)
Yes!
That works!!!
Thank you!
Glad to help
If the basic problem is solved
- it's always a good practice to show respect to the person(s) who have helped you
- is a click on the Add Reputation first (left lower corner of the post of person(s) who helped you) and then
- mark the thread as SOLVED (top right corner over your first post - Thread Tools). This is important for all of us,
Thanks
Now how do I mark this as solved???
You marked
Thanks for feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks