Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell
Look in the help index for VLOOKUP
-- Don Guillett Microsoft MVP Excel SalesAid Software "Steve" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell
Use VLOOKUP - if your reference data is on sheet2 with phone numbers
in column A and names in column B, and your other list of phone numbers is on Sheet1 starting in A2, then put this in B2: =VLOOKUP(A2,Sheet2A:B,2,0) and copy down. You must ensure that the phone numbers have the same format in both sheets, i.e. if you have leading zeros in one sheet then you must have the same in the other sheet. This looks for exact matches, but if the number does not appear in the second sheet the formula will return #N/A. Hope this helps. Pete On Oct 7, 3:01*pm, 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming a cell from VB | Excel Discussion (Misc queries) | |||
Cell and tab naming | Excel Discussion (Misc queries) | |||
tab naming from a set cell | Excel Discussion (Misc queries) | |||
Naming a cell | Excel Worksheet Functions | |||
Naming a cell | Excel Worksheet Functions |