One validation drop-down populates another?

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
 
B

Bob Phillips

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

=VLOOKUP(code, table, 2, False)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DATA VALIDATION/DROP DOWN LIST 1
Data Validation 1
validation drop down list question 1
How do I create a spreadsheet that populates q's from a drop down 3
Validation drop-down boxes 14
Drop down box issue 2
How do I create a drop down box within a drop down box? 1
Conditional Formatting - Comparing 2 columns 1

Top