Return Multiple Results with Lookup

J

Josh O.

I need to set a worksheet to pull numbers from another worksheet.
The first problem is multiple values. I need the spreadsheet (sheet 2 to
list all of the invoice numbers based on a single customer number, pulling
the data from another spreadsheet (sheet 1).

Second, it would be helpful if the spreadsheet (sheet 2) can pull all the
customer numbers that appear on the original spreadsheet (sheet 1).

I tried using Alan Beban's "vlookups" to return multiple values, but I can't
figure out how to get the formula to return the multiple values into sheet 2.

I would appreciates some more ideas or suggestions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
External cell reference between two excel worksheets both in One Drive 0
Multiple VLOOKUP in an IF statement 2
Excel formula help for calculating freight. 2
Lookup or search using the * character 1
lookup value if multiple matches are met 2
Page numbering with Merged Document and IF statements 1
Converting a number into a cell reference 2

Top