Vlookup - Returning Additional Values

D

Dave515 UK

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

Niek Otten

http://office.microsoft.com/en-us/assistance/HA012260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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/datamenu/dataexamples/externaldataexamples.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?
 
D

Dave515 UK

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
 
D

Dave515 UK

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

Duke Carey

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

Dave515 UK

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.
 
D

Duke Carey

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.
 
D

Dave515 UK

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

But thank you you have been more than helpful

D
 
Top