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.
Bookmarks