Replace Cell Content Automatically from List

[Kardon Coupé]

Dear All,

I regularly check my phone bills and see who I text and call, but when I
access my phone bill online, all I get is numbers, as they don't have the
names....

I was thinking, if I save this list out and have it in a sheet, excel can
look at another sheet and if the number matches replace the number with a
name..

Is this easy to do?

Regards
Paul.

 

[Dave Peterson]

You could build a table on that second sheet.

Column A would contain the phone numbers and column B would contain the name.
Name that sheet -- Table.

Then you could use a formula like this in an empty cell on the sheet with the
data:

=vlookup(a2,table!a:b,2,false)
You'll see an error (#n/a) if there isn't a match.

You could hide by changing your formula:

=if(isna(vlookup(a2,table!a:b,2,false)),"Missing",vlookup(a2,table!a:b,2,false)))

You could use =iferror() in xl2007 to hide the #n/a error.

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble

 

[Kardon Coupé]

That worked for me, thanks... =-)

You could build a table on that second sheet.

Column A would contain the phone numbers and column B would contain the
name.
Name that sheet -- Table.

Then you could use a formula like this in an empty cell on the sheet with
the
data:

=vlookup(a2,table!a:b,2,false)
You'll see an error (#n/a) if there isn't a match.

You could hide by changing your formula:

=if(isna(vlookup(a2,table!a:b,2,false)),"Missing",vlookup(a2,table!a:b,2,false)))

You could use =iferror() in xl2007 to hide the #n/a error.

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble