I'm attempting to work with a v-lookup that will have multipe results. In column A of my spreadsheet are invoices numbers and in column B are account numbers. An invoice can have multiple accounts. For example, there are two lines for invoice "ABC", each with a different result in column B (see below)

__Invoice__

__Account__

ABC Cash

ABC Receivable

My goal is to have the vlookup bring in both values, but in separate rows (see below)

__Column A__

__Column B__

__Column C__

ABC Cash Receivable

Is this possible? Thanks in advance for any help.