Linking to dopdown list

[chrismcon]

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

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

 

[Debra Dalgleish]

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]

Many thanks Debra

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