| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using a lookup to return multiple values in one cell??
Ok, basically I want to do a lookup to return some figures... I know
all the VLOOKUP, etc... trouble is I don't just want to return one figure. It may be 1 figure but then it may be about 9/10 as well. I've got a list of order numbers and a list of orders that need an invoice date next to them. So I've done a bog standard vlookup and it only returns one figure where as there might be 10 invoices related to 1 order... make any sense :? (Table 1) Order Number................... Invoice Date 10010001....................... 22/11/05 10010001....................... 14/10/05 10010002....................... 25/09/05 10010002....................... 21/12/05 10010002....................... 23/11/05 10010002....................... 05/10/05 10010002....................... 15/11/05 10010003....................... 20/12/05 etc... (Table 2) Order Number.... Supplier.... Invoice Date 10010001........ xxxxxxxx.... *lookup from table 1* 10010002........ xxxxxxxx.... *lookup from table 1* 10010003........ xxxxxxxx.... *lookup from table 1* |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Using a lookup to return multiple values in one cell??
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| return multiple corresponding values in excel | Excel Worksheet Functions | |||
| How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
| Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
