Vlookup - Returning Additional Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/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?
 
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
 
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?
 
I'm not following your question. Do you want to get the data back in some
for other than 1 row per address?
 
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.
 
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.
 
This is not reallty practiacal as the sheet is for multipul user's.

But thank you you have been more than helpful

D
 
Back
Top