| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically fill in postcodes
Hello Group,
Is there a way to have the postcodes for a suburb in excel automatically filled in into the adjacent cell? e.g. if i type new york in a1, can i get the post code automatically filled into b1? And so on, for different towns? Thank you!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically fill in postcodes
Hi Eternal Cat,
SeeVLookup in Excel help. See also Debra Dalgleish's tutorial at: http://www.contextures.com/xlFunctions02.html --- Regards, Norman "eternal_cat via OfficeKB.com" <u14645@uwe wrote in message news:5575b4048719c@uwe... Hello Group, Is there a way to have the postcodes for a suburb in excel automatically filled in into the adjacent cell? e.g. if i type new york in a1, can i get the post code automatically filled into b1? And so on, for different towns? Thank you!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically fill in postcodes
Will vlookup fill in the postcodes automatically? It seems that I will have
to enter a formula every time. Norman Jones wrote: Hi Eternal Cat, SeeVLookup in Excel help. See also Debra Dalgleish's tutorial at: http://www.contextures.com/xlFunctions02.html --- Regards, Norman Hello Group, [quoted text clipped - 5 lines] Thank you!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically fill in formula | Excel Discussion (Misc queries) | |||
| Fill Chart Automatically | Charts and Charting in Excel | |||
| Postcodes | Excel Worksheet Functions | |||
| ADDING POSTCODES AUTOMATICALLY | Excel Programming | |||
| Copy and fill automatically | Excel Programming | |||
Hybrid Mode
