One validation drop-down populates another?

  • Thread starter Thread starter Custard Tart
  • Start date Start date
C

Custard Tart

Hi there,

I'm having some problems with finding information on one drop-down
list automatically populating another.

Basically in Column A, the property code of the building appears. I
want Column B to automatically populate the cell with the correct
address based on the property code I have chosen.

I've googled to no avail.

Any suggestions?

Thanks,
CT
 
You need to have a table of property codes and addresses and use VLOOKUP

=VLOOKUP(code, table, 2, False)
 
Back
Top