Use OFFSET in INDEX MATCH MATCH

[BRISBANEBOB]

I am trying to figure out how to return the second instance of a criteria in an array. The attached workbook explains it exactly. Any help appreciated.

[FlameRetired]

Not OFFSET but an array formula. Array entered in J29 and filled down.

Please Login or Register  to view this content.

[BRISBANEBOB]

Thanks Dave. It works perfectly.

From the purely academic perspective, can you use OFFSET with MATCH?

[FlameRetired]

Yes. Array entered.

Please Login or Register  to view this content.

[BRISBANEBOB]

Thank you for that, folks. Magic.

[Czeslaw]

I propose to use the function AGGREGATE.

Please Login or Register  to view this content.

Write it in J29 cell and drag it down.