How to return multiple unique invoice numbers of a sales order

[ameenuksg]

Hi All - I tried using index match to return matching results for sales order# 133213 which is duplicated in the row below in Sheet 1, Column A. But it always returns only the first invoice# it could find on Sheet 2, Column A for both rows in Sheet 1, Column F. Appreciate any help, and thank you so much in advance ?

Column A	Column F	Column A	Column E
Sales Order#	Invoice#	Invoice#	Sales Order#
133213		6700000456	133213
133213		6700000443	133213
121323		6700000478	121323
Sheet 1	Sheet 1	Sheet 2	Sheet 2

 

[Toadstool]

I assume you're saying it finds no match so search another table?
You'll need another INDEX/AGGREGATE so just use IFERROR
=IFERROR(existingindexaggregate),newindexaggregate