# Combining INDEX/MATCH with several criteria and INDEX/SMALL

1. ## Combining INDEX/MATCH with several criteria and INDEX/SMALL

I am playing around with Index in an effort to finally learn it.
I have however come to a snag for which I cannot find a thread.

I would greatly appreciate if someone could point me to the correct thread or a solution!

I have found a way to find a value that meets three criterias:
``Please Login or Register  to view this content.``
This only finds the first value, and not the rest.

I have also found a way to find all the values, (and sort them in multiple columns), but this only accepts one criteria:
``Please Login or Register  to view this content.``
How do I combine these into one sentence?

I tried by entering an AND statement to the IF statement in the second, but this returns the heading of the column in the table where I look.

3. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

Originally Posted by tim201110
Thank you for the quick reply!
This does however only return the heading of the table, and nothing more.

Excel INDEX MATCH SMALL.gif

4. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

5. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

Originally Posted by shukla.ankur281190
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I have done so!

not array

7. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

Originally Posted by tim201110
not array
Super! This works. Thank you very much!
As it is now not an array anymore. How do one lock Data_Entry[[#All];[NPS E-mail adress]] like \$B4 to prevent it from changing when copying the cells to other cells?

8. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

Try the following modification of Tim's formula:
Formula:
`Please Login or Register  to view this content.`

Let us know if you have any questions.

9. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

I have tried that, but it only returns the last entry. Copy paste works for now. I was just curious.

Thank you for your help and assistance!

10. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

It only shows one email address if PM is in cell B3 on the Menu sheet because there is only one email address that is associated with PM. If Brake & Fix is placed in cell B3 then the formula shows both associated email addresses as modeled in row 8 of the attached copy of the file.
Let us know if you have any questions.

11. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

Ahh!

I had a write error in the real file. Thank you very much!

12. ## Re: Combining INDEX/MATCH with several criteria and INDEX/SMALL

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you have a blessed day.

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