Hi,

I'm trying to set up a formula so that I can extract rows from a big flat file, based on different criteria in the same column. I know you can do this with advanced filtering, but I need it to be formula driven.

For example, I would like to take the below to be filtered to include rows that contain ABA, ABC and ABD only, and then of those rows, only those that contain Hong Kong and England.

Code Country Price
ABA England 1
ABA Finland 1.36
ABC England 4.68
ABC Hong Kong 5.31
ABD Singapore 1.63
ABD US 2.48
ABH Mexico 6.14
ABH India 5.04

I can do it based on 1 criteria from each column using an index match array, but cannot do it from multiple criteria in the same column. Please could someone help??

Thanks!