INSERT/MATCH Function - can I match and return more than a single result?

Like, if I had a list like the following

- 1 AAA
- 1 BBB
- 2 CCC
- 3 AAA

And I want a Insert/Match function that shows all the results simultaneously after I match "AAA".

Thanks in advance.

You need to give a bit more information than that. What do you want to return - the row numbers where those matches occur? Do you want those in a separate list?

Pete

I was using Vlookup until I found out that Index/Match is a better form of Vlookup.

Basically, I need to return all the figures that match the initial criteria (Display all rows that have "1" and all their data).

If not Index/Match, is there a better way?

Yes, you can use INDEX/MATCH, with maybe another formula to identify the records that match. Can you post an example workbook? (The FAQ describes how to).

Pete