English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

im entering mobile phone nos and i want excel to show the person's name.

something like conditional formatting

2006-06-12 21:50:31 · 3 answers · asked by Anonymous in Computers & Internet Software

i hav 1 sheet starting from a1. A contains names. b theri cell nos.
it like
a b
1 abc 123
2 zyw 235...

now supose at other sheets i hav nos at d
ie
a b c d e
1 123
2 235
4
n so on.

now i want excel to display this as
a b c d e
1 abc
2 zyw
4

pl help. thanx.

2006-06-12 23:00:39 · update #1

___a_____b
1_abc___123
2_xyz___345

and

__A___b____c____d
1______________123
2______________345
3

i want
__A___b____c____d
1______________abc
2______________xyz
3

2006-06-12 23:02:58 · update #2

3 answers

Very little information there. If you already have the names and telphone numbers in a seperate excel file or on another sheet) then
you can use the vlookup function.

Your functiom ight look something like this:
=IF(ISBLANK(C2),0,VLOOKUP(A2,$A$16:$B$19,2,TRUE))

C3 is the cell where you type in the number,

$A$16:$B$19
$A$16 is the starting block of your table with names and telephone numbers are stored.
$B$19 is the last row of the last column of the table where the telephone mumbers and names are stored.
you can have many columns and rows if you like.

the 2 represents the column from which Excel must take the data, so if column 1(A) is where telephone numbers are store and column 2(B) is where the names are stored then it will look up the name of the person.

The paramaters of the if statement are up to you depending on how you want excel to process the data.

the only other advice i can give you is to learn Visual basic and/or program a macro to do it for you.

2006-06-12 22:30:51 · answer #1 · answered by jason b 5 · 0 0

Perhaps you should have a look at creating it in Access, as a database.
The way you want to search for things, is the way a database is made to work.
After creating the initial table, 1 123, xyz, etc, you can create a query on the table, using the name, and inputting the number. You could create another query, thats works the other way, input a name, and get a number.

I do not know ho much help is available from Access to do this.

2006-06-18 01:03:50 · answer #2 · answered by Mark aka jack573 7 · 0 0

Not quite sure how you are trying to set it up, but if you have a list with names and phone numbes, you can always type "CTRL+F" to bring up a search box, then enter the last four numbers of the phone number, and it will take you to the box with the full number; you will see the name next to it. This is how I have my list of 400 CD's set up to find what I want. Hope this helps.

2006-06-13 04:56:20 · answer #3 · answered by Garth 6 · 0 0

fedest.com, questions and answers