How To - Populate a field from the of a drop down box selection?

[NRGZ]

Hi,

I have an excel workbook that holds the value choice for the drop down box and what i would like it to do populate 2 other fields in the table based on the selection made.
Workbook - 3 columns - Account number, Company Name, Postcode
(this workbook is static information)
Table - Account Code (drop down box) - Company Name - Postcode - (other fields do exist but not relevant)

I know this must be easy but having a mental block plus i'm new to the whole VBA thing.
Thanks in advance,
o/

 

[Crystalyzer]

You don't need VBA for this. Just some VLOOKUP formulas

Book7
	A	B	C	D	E	F	G	H	I
1	Account Number	Company Name	Postcode
2	1	A	12345
3	2	B	12346
4	3	C	12347
5	4	D	12348
6	5	E	12349
7
8
9
10
11
12							Account Number	Company Name	Postcode
13							2	B	12346
14							3	C	12347
15							4	D	12348
16							1	A	12345
17							5	E	12349
Sheet1

Cell Formulas
Range	Formula
H13:H17	H13	=IF($G13<>"",VLOOKUP($G13,$A$2:$C$6,2,0),"")
I13:I17	I13	=IF($G13<>"",VLOOKUP($G13,$A$2:$C$6,3,0),"")

Cells with Data Validation
Cell	Allow	Criteria
G13:G17	List	=$A$2:$A$6

 

[welshgasman]

Crossposted with responses for Access solution. How to? - Auto populate 'text boxes' with values from selection made from another field.