Intelligent lookup of a suburb

[Mike Langensiepen]

I'd like to be able to do an intelligent lookup of a suburb and then have
the postcode automatically show in another cell. I can do the vlookup of the
postcode once i have the suburb but I'd prefer not to have to use a dropdown
box for the suburb (there are THOUSANDS!)

Any suggestions? - in an access database I have it 'suggesting' suburbs as
you type - can you do something similar in Excel?

Thanks

Mike

 

[Don Guillett]

You could use a worksheet_change event that fires when you type in the name.
Or dropdowns that bring up other dropdowns upon selecting the 1st letter, ??

 

[Guest]

You might look at http://www.contextures.com/tiptech.html - drop down to the
'D' list and check out some of the various Data Validation options. Pay
particular attention to the ones mentioning using either a Combo box or as
'dependent lists'?

 

[Mike Langensiepen]

Contextures has been very helpful so far - I'll take another look. Thanks.