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

=VLOOKUP(code, table, 2, False)

--
__________________________________
HTH

Bob

"Custard Tart" wrote in message
...
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