Lisa,
Even a VLOOKUP() would not handle multi-field match, not without some smoke
and mirrors of some type, although a variation of SUMPRODUCT() might do the
trick.

If you'd like to try to work out a solution with me 'off-line', feel free to
get in touch with me at (remove spaces) Help From @JLatham site.com


"Lisa" wrote:

Yes this suggestion is good the only issue I am having is when I choose the
Parameters area it only lets be pull data from one cell i need to pull data
from a range and it does not allow this; see my example below.

Based on the data in column A and B i need information queried to populate
columns C, D and E. Each column A and B combination information is unique.

Column
A B C D E
data1 data1 queried queried quiered
data2 data2 queried queried quiered
etc...

--
lmo


"JLatham" wrote:

Best way, with least work in the long run for you, is to probably use Excel's
Import Data features to create a 'query' into the Access database directly.

Start by using Excel's Help and enter
About exchanging data between Excel and Access
as the search subject. There's actually a topic of that title (Excel 2003).
Look at the section on "Bring refreshable Access data into Excel" for more
guidance and examples.

Hope this helps get you started -- you can always ask more questions as you
dig in to your solution.


"Lisa" wrote:

Is there a way to process a vlookup to a text file or access database.

I have very large access files that if needed i can convert to text files.
I need to pull a couple of columns to an excel file based on one column
possibly via a vlookup. This excel file data is constantly changing and i
need to pull data from a database.

What would be the best way get the data when needed into the excel file?
--
lmo