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