I would like to find a way to pull values (mostly text) from an Excel 2003
spreadsheet and put them into a form in another worksheet. I'd like to find
a way to change the information in the form by entering the client's name and
have the function pull the last entry for that client from the original
spreadsheet.

I vaguely remember there might be a way to do this with the lookup function,
but because of how the original worksheet is arranged, I'm not sure if or how
I can use the lookup function. The only field that is unique to each record
is the contract number, but not every record has a contract number, and that
field is not the first field.

Normally, I would have taken this blankety blank spreadsheet and thrown it
into Access (where it belongs), but the powers that be in this company want
it in Excel.

I have zero programming experience, and I'm stumped. Any suggestions would
be greatly appreciated. Thanks.
--
I doubt, therefore I might be.