dynamic data lookup by cell

[Guest]

I need some code to do a database lookup for each cell in specific cell range
that is not emply (e.g. a2-a250) and return a single record from the database
with a select using the value in that cell in the where clause.

I'm thinking the sql will be something like: "select jobname from jobs where
jobid = " (i don't know how to put in the cell reference, or the vb code
around it)

Can someone help me?

 

[Jean]

We're in the same boat, I am trying to do same thing, I
know it can be done, just can't figure out how to do it.

If you ever get yours to work I'd appreciate knowing how
you did it. Thank you.
Jean
(e-mail address removed)