Index a column based on matching 2 separate values

[Pauljj]

I need to index column H based on matching E2 in column B and matching F2 in column C. It may be worth noting that I am indexing text not numerics. As I had planned to use the following array formula but this only works with numerics

=MIN(IF(B1:B5000=E2,IF(C1:C5000=F2,H1:H5000)))

It is also worth noting that there maybe dupicates of E2 in column B and duplicates if F2 in column C but the combination of E2 and F2 will be unique

I understand concatenating might be the only option but its just not idea

Thanks in advance

 

[Andrew Poulsom]

Like this?

=INDEX(H1:H5000,MIN(IF(B1:B5000=E2,IF(C1:C5000=F2,ROW(H1:H5000)))))

Remember to confirm with Ctrl+Shift+Enter.

 

[Pauljj]

Many thanks Andrew, as always....works a treat