Add address based on text from drop down menu.

[Geek Girl 007]

Sheeela's Accounts.xlsx
	A	B
4	Invoice information
5
6	Invoice Number:
7	To:
8	Address:
9
10
11
12	Function:
13	Date:
14	Duration:
15	Cost:
INVOICE

Cells with Data Validation
Cell	Allow	Criteria
B7	List	=TABLES!$A$2:$A$5

If I select 'The Grapes' from cell B7 I want the address 12 Dow Street, SW12 3TH to appear in B8 however If I select 'Shaftesbury Club' I want the address 1 Peter Close, SE11 3GH to appear, and so forth.

Can this be done??

 

[mumps]

@ Fluff
Thanks for that formula. I tried the same one but I forgot to delete the macro which caused the formula to be overwritten when I changed B7.

 

[Geek Girl 007]

How about

Fluff.xlsm
	A	B
1
2
3
4	Invoice information
5
6	Invoice Number:
7	To:	Shaftesbury Club
8	Address:	128 Lavender Hill, London, SW11 5RB
9
10
11
12	Function:
13	Date:
14	Duration:
15	Cost:
Sheet5

Cell Formulas
Range	Formula
B8	B8	=VLOOKUP(B7,Main!A2:B4,2,0)

Cells with Data Validation
Cell	Allow	Criteria
B7	List	=Main!$A$2:$A$4

Sorry for the delay, this is PERFECT for my purposes, thank you !!!
Happy New year Fluff

 

[Fluff]

Glad we could help & thanks for the feedback.