Intelligent lookup of a suburb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Langensiepen - 28 May 2007 07:52 GMT

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

Reply to this Message

Don Guillett - 28 May 2007 13:39 GMT

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, ??

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> 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
[quoted text clipped - 7 lines]
>
> Mike

Reply to this Message

Mike Langensiepen - 02 Jun 2007 01:29 GMT

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

> 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
[quoted text clipped - 11 lines]
>>
>> Mike

Reply to this Message

JLatham - 31 May 2007 04:21 GMT

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'?

> 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
[quoted text clipped - 7 lines]
>
> Mike

Reply to this Message

Rate this thread: