Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
Josh O. wrote...
.... I would appreciates some more ideas or suggestions Stay in your original thread. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup multiple occurrences of a value excel | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions |