MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Run a Query against a Range???


Posted by mobius on September 03, 2001 10:21 PM

How the heck can I run a parameter query against a range of cells, one by one? i.e - cells a1 - a100 contain numbers - I want to test a match for the value of each cell against a database, and return 2 columns of query results to the spreadsheet...

I can run a parameter query OK, but I would have to type in each cell's value individually - there must be a better way!

HHHEEEELLLLPPP!!!!!


Posted by Gyula on September 04, 2001 1:13 AM


You could probably use VLOOKUP.
If you prefer a macro, please provide more details.

Posted by Gyula on September 04, 2001 1:13 AM


You could probably use VLOOKUP.
If you prefer a macro, please provide more details.