Assume your name, address and phone number are in columns A, B and C,
with data starting on row 2 to allow for headings. Use E1 to enter a
name and put this formula in F1:

=IF(ISNA(VLOOKUP(E1,A$2:C$1000,3,0)),"not found",VLOOKUP(E1,A$2:C
$1000,3,0))

I've assumed you have data up to row 1000 - adjust if you have more.

Hope this helps.

Pete

On Dec 6, 6:11 pm, Kane wrote:
I have an excel table containing name address and phone number.

I would like to enter a name in one cell and have another cell display the
phone number for that name from the table. I think vlookup can do this, but
I am having diffculties getting it to work.

Please post any formula suggestions that should make this work. Thanks.