# INDEX/MATCH formula to match 3 criteria

1. ## INDEX/MATCH formula to match 3 criteria

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.

Thank You!

2. ## Re: INDEX/MATCH formula to match 3 criteria

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)

3. ## Re: INDEX/MATCH formula to match 3 criteria

Yes!
That works!!!
Thank you!

4. ## Re: INDEX/MATCH formula to match 3 criteria

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

5. ## Re: INDEX/MATCH formula to match 3 criteria

Now how do I mark this as solved???

6. ## Re: INDEX/MATCH formula to match 3 criteria

You marked
Thanks for feedback

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1