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?

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?

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?

Hi This looks to be what I need, I will give it a go

"Duke Carey" wrote:

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?

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?

Thanks

I have tried this and it running this QRY returns all the information that I
need. However is there anyway that I can formatt the returning Data anything
other than row formatt? I say this as I have 21 colums of onfo including
opening close tomes etc.

Is this asking too much of excel?

"Duke Carey" wrote:

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?

I'm not following your question. Do you want to get the data back in some
for other than 1 row per address?


"Dave515 UK" wrote:

Thanks

I have tried this and it running this QRY returns all the information that I
need. However is there anyway that I can formatt the returning Data anything
other than row formatt? I say this as I have 21 colums of onfo including
opening close tomes etc.

Is this asking too much of excel?

"Duke Carey" wrote:

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?

Hi Sorry for the delayed reply,

You are exactly correct, A bit like an Access report might. Problem is that
I need to use excel due as the document will be published on MS sharepoint
and there are other restrictions.

"Duke Carey" wrote:

I'm not following your question. Do you want to get the data back in some
for other than 1 row per address?


"Dave515 UK" wrote:

Thanks

I have tried this and it running this QRY returns all the information that I
need. However is there anyway that I can formatt the returning Data anything
other than row formatt? I say this as I have 21 colums of onfo including
opening close tomes etc.

Is this asking too much of excel?

"Duke Carey" wrote:

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?

You can always set the query up to return the data you need, maybe on a
separate worksheet, and then use normal Excel functions to reference the
returned data and display it in some other layout.


"Dave515 UK" wrote:

Hi Sorry for the delayed reply,

You are exactly correct, A bit like an Access report might. Problem is that
I need to use excel due as the document will be published on MS sharepoint
and there are other restrictions.

"Duke Carey" wrote:

I'm not following your question. Do you want to get the data back in some
for other than 1 row per address?


"Dave515 UK" wrote:

Thanks

I have tried this and it running this QRY returns all the information that I
need. However is there anyway that I can formatt the returning Data anything
other than row formatt? I say this as I have 21 colums of onfo including
opening close tomes etc.

Is this asking too much of excel?

"Duke Carey" wrote:

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?

This is not reallty practiacal as the sheet is for multipul user's.

But thank you you have been more than helpful

D

"Duke Carey" wrote:

You can always set the query up to return the data you need, maybe on a
separate worksheet, and then use normal Excel functions to reference the
returned data and display it in some other layout.


"Dave515 UK" wrote:

Hi Sorry for the delayed reply,

You are exactly correct, A bit like an Access report might. Problem is that
I need to use excel due as the document will be published on MS sharepoint
and there are other restrictions.

"Duke Carey" wrote:

I'm not following your question. Do you want to get the data back in some
for other than 1 row per address?


"Dave515 UK" wrote:

Thanks

I have tried this and it running this QRY returns all the information that I
need. However is there anyway that I can formatt the returning Data anything
other than row formatt? I say this as I have 21 colums of onfo including
opening close tomes etc.

Is this asking too much of excel?

"Duke Carey" wrote:

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?