If you have entered the number in A1 on Sheet 1 and you have your number &
name in Sheet 2 in Col A (number) & B (name) then enter in B1 of Sheet1 -
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"Steve" wrote:

I have a list of telephone numbers and what I'm trying to do is to add the
company name against them in another cell?!
So i have the number, and company name in another workbook for example, and
i am trying to get it so that it shows the name and number in one
spreadsheet?!
Or basically i type in the numner and it automatically searches and fiinds a
company name tpo referance against it?!
Thanks
Steve