Find mulitple records Vlookup type function?
 

Hello,

I have two spreadsheets. SheetA contains mulitple records of the same
invoice, each record contains the invoice number in the INVNBR column but
provides details on different rows of the invoice.
SHEETB contains a list of invoice numbers (and other data).
I would like to be able to perform something like a vlookup using the SHEETB
Invoice Number to find all instances of the SHEETA Invoice Number.
Unfortunately Vlookup only returns the first exact match it finds even if
there are more exact matchs in SHEETB.

Is there such an animal without resorting to Visual Basic or some other
language?

Thanks,
Kerry