Looking for an Easy way to Achive a Result

[Kardon Coupé]

Dear All,

I've decided to keep track of phone numbers dialed and the phone provider
I'm with allows viewing of the bill, but it only displays numbers...

So I copied and pasted it into Excel, now I'm looking for a way to automate
a column creation so that is checks the number in the number column and puts
a name in another column...

Is it easy to acheive?

Regards
Paul.

 

[Niek Otten]

Hi Paul,

Check this tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Dear All,
|
| I've decided to keep track of phone numbers dialed and the phone provider
| I'm with allows viewing of the bill, but it only displays numbers...
|
| So I copied and pasted it into Excel, now I'm looking for a way to automate
| a column creation so that is checks the number in the number column and puts
| a name in another column...
|
| Is it easy to acheive?
|
| Regards
| Paul.
|
|

 

[Kardon Coupé]

Hi Niek,

I think I understand that....

But (and there is always a but) I understand the instructions are showing me
how to replace a cell with something from another sheet?

Can this be used so the cell of reference remains the same, but another cell
is the one that displays the deatils from the lookup table?

Regards
Paul

 

[Kardon Coupé]

Oooh, just tried it, and it works from another column.....

If I add more data into the table, have I gotta sort all the lookups again?

 

[Niek Otten]

| But (and there is always a but) I understand the instructions are showing me
| how to replace a cell with something from another sheet?

No

| Can this be used so the cell of reference remains the same, but another cell
| is the one that displays the deatils from the lookup table?

Yes, like in

=VLOOKUP(B1,C122,2,FALSE)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| | > Hi Paul,
| >
| > Check this tutorial:
| >
| > http://www.contextures.com/xlFunctions02.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | Dear All,
| > |
| > | I've decided to keep track of phone numbers dialed and the phone
| > provider
| > | I'm with allows viewing of the bill, but it only displays numbers...
| > |
| > | So I copied and pasted it into Excel, now I'm looking for a way to
| > automate
| > | a column creation so that is checks the number in the number column and
| > puts
| > | a name in another column...
| > |
| > | Is it easy to acheive?
| > |
| > | Regards
| > | Paul.
| > |
| > |
| >
| >
|
|

 

[Niek Otten]

<have I gotta sort all the lookups again?>

No.
Either insert new data before the last row (which will adjust the formulas automatically) or use a defined name for the table, so
you just have to redefine the range that it refers to, without altering the formulas.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Oooh, just tried it, and it works from another column.....
|
| If I add more data into the table, have I gotta sort all the lookups again?
|
| | > Hi Niek,
| >
| > I think I understand that....
| >
| > But (and there is always a but) I understand the instructions are showing
| > me how to replace a cell with something from another sheet?
| >
| > Can this be used so the cell of reference remains the same, but another
| > cell is the one that displays the deatils from the lookup table?
| >
| > Regards
| > Paul
| >
| > | >> Hi Paul,
| >>
| >> Check this tutorial:
| >>
| >> http://www.contextures.com/xlFunctions02.html
| >>
| >> --
| >> Kind regards,
| >>
| >> Niek Otten
| >> Microsoft MVP - Excel
| >>
| >> | >> | Dear All,
| >> |
| >> | I've decided to keep track of phone numbers dialed and the phone
| >> provider
| >> | I'm with allows viewing of the bill, but it only displays numbers...
| >> |
| >> | So I copied and pasted it into Excel, now I'm looking for a way to
| >> automate
| >> | a column creation so that is checks the number in the number column and
| >> puts
| >> | a name in another column...
| >> |
| >> | Is it easy to acheive?
| >> |
| >> | Regards
| >> | Paul.
| >> |
| >> |
| >>
| >>
| >
| >
|
|