Hi Zim,
Use Data>Filter>Autofilter instead
HTH
--
AP
"zim_zimmer" <paul_mittoo[ at ]hotmail.com> a écrit dans le message de news:
1152263442.387091.138770[ at ]m79g2000cwm.googlegroups.com...
[Quoted Text] > 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*
>
|