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?