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