Hi Niek,

I have previously tried this, but it was less helpful as the adressess that
I wish to return are in multiple columns.

Thanks anyway

"Niek Otten" wrote:

http://office.microsoft.com/en-us/as...260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Duke Carey" wrote in message ...
| Nick Hodge has some good advice on his website about how to use queries in
| Excel to pull in data from an external source. The source he specifically
| uses is an Access database, but it could just as easily be an Excel worksheet.
|
| Look for this topic:
| Using Parameters In External ODBC Data Queries
|
| at this site:
| http://www.nickhodge.co.uk/gui/datam...taexamples.htm
|
|
|
| "Dave515 UK" wrote:
|
| Hi,
|
| I am trying to create a easy to use look up tool for adresses. IE a user
| will enter a Postcode(zip code) and a number (say 8) Adresses will be
| returned. I have used Vlookup and this returns the first value it finds. Is
| there a away of returning the next value, and the next and so on?