This sounds like a great idea. However the cells that I will be pulling
from are not static.

I want to look up a customer from row 27 with SSN: xxx-xx-xxxx, and
then maybe I will look up the next customer on row 45. with ssn:
xxx-xx-xxx2.

How can I set the control source to a different cell based upon which
customer I look up. All of the SSN's will be from the same column, but
each ssn is on a diff. row.

WILL A CONTROL SOURCE WORK? OR IS THERE A ANOTHER SOLUTION?

Mike


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=274237