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!!!

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!!!

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!!!