LinkBack URL
About LinkBacks
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)
sandy
How to create an editor for Power Query with Notepad++ (tutorial)
How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
Tips for Excellent Spreadsheets
What makes learning so hard is the amount of knowledge you have to unlearn
Why is my program not doing what I expect?
Because you set the wrong expectations. Rewire your brain
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)
Posting Permissions
Register To Reply
Bookmarks