Hi!

Try this:

This table is on Sheet2 in the range A2:C4 -

Ann 555-1234 555-0000
Bob 555-5678 555-1111
Claire 555-9012 555-2222

Sheet1:

A2 = Ann

Enter this formula in B2 and copy across to C2:

=IF($A2="","",VLOOKUP($A2,Sheet2!$A2:$C4,COLUMNS($ A:B),0))

Biff

"Laura" wrote in message
...
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.