Vlookup multiple data

[jp16]

My data is as below,

ABC Pte Ltd
INV123
INV222
INV172

BBB Pte Ltd
INV291
INV281


How is it able to have a Vlookup function that will give me the list of the invoices of that company?
FYI, the company name is in Column A while Invoice number is in Column B. I try using vlookup, however, it only generated the first invoice.

[NBVC]

Try adding helper columns to help identify the relevant rows first.

So if you have your data starting in say A2 and B2, then in C2 enter:

=IF(B2="","",INDEX($A$2:A2,MATCH(REPT("Z",255),$A$2:$A2)))

copied down

in D2 enter:

=IF(C2=Sheet2!A$1,COUNT($D1:$D$1)+1,"")

Where Sheet2!A1 contains the Company you want to search for.

Then in Sheet2, enter:

=IFERROR(INDEX(Sheet1!B:B,MATCH(ROWS($B$1:$B1),Sheet1!$D:$D,0)),"")

copied down, where Sheet1 contains the database...

[jp16]

Hey, i tried. But however, it does not seems to work. Mind if you email me a sample?

[NBVC]

See attached.