Is this possible?
I would like to create a LOOKUP formula that would tell me the phone number
if I put in the name.

For instance, I have one worksheet that looks like this:

Name Home Cell
Ann 555-1234 555-0000
Bob 555-5678 555-1111
Claire 555-9012 555-2222

On another worksheet, I want to set-up a formula so that if I enter a name
in A2, the home # will be generated in B2 and the cell # will be generated in
C2.

Any ideas?

Thanks.