VLOOKUP (or similar) to a datasource rather than a worksheet

[matpj]

Is this possible?
I've just realised that the data I need to use in one of my worksheets comes from a table with hundreds of thousands of rows.
I only need to retrieve values with Project numbers from a list in another worksheet (of which there are about 600)
Is it possible to perform a VLOOKUP (or just any database query in EXCEL, with values in a worksheet as the criteria???


Matt
London (UK)

 

[gizmo1973]

Short answer is yes, if there is a unique number pertinent to each table
Post back if you want to know more, there is a equation that means you don't have to retype each look up

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[matpj]

Hi,
I would like to know more!

in the main worksheet the key field is Project Number.
It appears only once for each project.

I need to retrive all of the finance actuals for each of those projects from a table with multiple occurances of each project number.

thanks,



Matt
London (UK)

 

[gizmo1973]

Arghhh, I've just re-read your post and my answer is wrong.
Easiest way is to take you values in the Excel sheet and turn into an Access table (presume that is your data source?) and then query the two tables together to get the data on one table then export back to Excel,
Sorry for the confusion!!

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[xlbo]

Have a look at the SQL.Request function:
faq68-4089

Seems to be pretty much what you want - bit complicated to get your head round but VERY powerful when you do

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[gizmo1973]

That'd be a one to many relationship in you link in your query in Access.

i.e. All records in your financial actuals where they match your project number

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts