Linking to dopdown list

Hi there,
I have a list of people that I invoice on a fortnightly basis. I would
like to create an invoice whereby when I select a name from a drop down
list, this selection auto-populates other cells on the invoice such as
TAX ID number, Client number and banking details, all of which I have
in seperate lists.

EXAMPLE:
I select John Doe from my drop down list and this automatically
populates cells with John Doe's TAX no., etc etc.
Any help would be much appreciated


--
chrismcon

YOu can use VLookup formulas to return the matching data. There's
information here:

http://www.contextures.com/xlFunctions02.html

And a sample here which fills in Customer info on an order form:

http://www.contextures.com/xlOrderForm01.html#Customer

chrismcon wrote:
> Hi there,
> I have a list of people that I invoice on a fortnightly basis. I would
> like to create an invoice whereby when I select a name from a drop down
> list, this selection auto-populates other cells on the invoice such as
> TAX ID number, Client number and banking details, all of which I have
> in seperate lists.
>
> EXAMPLE:
> I select John Doe from my drop down list and this automatically
> populates cells with John Doe's TAX no., etc etc.
> Any help would be much appreciated
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Many thanks Debra
Debra Dalgleish Wrote:
> YOu can use VLookup formulas to return the matching data. There's
> information he
>
> http://www.contextures.com/xlFunctions02.html
>
> And a sample here which fills in Customer info on an order form:
>
> http://www.contextures.com/xlOrderForm01.html#Customer
>
> chrismcon wrote:
> Hi there,
> I have a list of people that I invoice on a fortnightly basis. I
> would
> like to create an invoice whereby when I select a name from a drop
> down
> list, this selection auto-populates other cells on the invoice such
> as
> TAX ID number, Client number and banking details, all of which I have
> in seperate lists.
>
> EXAMPLE:
> I select John Doe from my drop down list and this automatically
> populates cells with John Doe's TAX no., etc etc.
> Any help would be much appreciated
>
>
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html


--
chrismcon