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*

Using a lookup to return multiple values in one cell??
 

Hi Zim,

Use DataFilterAutofilter instead

HTH
--
AP

"zim_zimmer" a écrit dans le message de news:
...
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*