Okay, I feel like this should be easy since I'm now using Excel 2010, but I still don't see a good way to do database queries from a cell based on another cell's value. Essentially I have a sheet where column "A" is a database identifier that someone wants to look up. They might put in 1 or they might put in 1,000 values into column "A"

I want to populate columns "B" to "L" or some number based upon a database query using the adjacent value from "A"

If they add a new identifier in column A, run the query populate the columns next to it.

Seemed straight forward to me, but I couldn't figure out a nice easy way to do it. I just switched to Excel 2010 and I was really expecting some better database capabilities (perhaps even the ability to do a formula query like "=dbquery(connection,query,param1)" but I'm not finding it.

Is the only way to do this sort of Excel work with VBA or is there a way to do it without code. I've done mass queries that return multi-row multi-column dataset based on in-sheet parameter values before, but I've never done anything like this to do it with multiple queries returning one row each.

And yes I understand running a query per row is not efficient, but I'm not worried about performance in these cases.

Any help would be appreciated!

Thanks.