| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One validation drop-down populates another?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One validation drop-down populates another?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a spreadsheet that populates q's from a drop down | Excel Worksheet Functions | |||
| drop down list populates data in another cell | Excel Discussion (Misc queries) | |||
| Creating a Fill In form that populates a table | Excel Discussion (Misc queries) | |||
| Dropdown List that populates another column | Excel Worksheet Functions | |||
| Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
Hybrid Mode
