Here's info on how to use the LOOKUP function:
http://www.techonthenet.com/excel/formulas/lookup.php

Without knowing what your spreadsheet looks like it would be impossible to
tell if you could use it.

As for Access--if the powers that be care only about the end result, why do
they care how you get to it? You're right that Access sounds perfect for
what you're looking to do. Excel isn't a database program and shouldn't be
used as such, even if it does have db capabilities like LOOKUP, VLOOKUP, etc.
It has very limited ways of forcing data integrity. But I'm sure you know
all this.

Dave
--
Brevity is the soul of wit.


"bigwerdz" wrote:

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.