Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Looking for an Easy way to Achive a Result
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Looking for an Easy way to Achive a Result
Hi Paul,
Check this tutorial: http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Kardon Coupé" wrote in message ... | 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. | | |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Looking for an Easy way to Achive a Result
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 "Niek Otten" wrote in message ... Hi Paul, Check this tutorial: http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Kardon Coupé" wrote in message ... | 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. | | |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Looking for an Easy way to Achive a Result
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? "Kardon Coupé" wrote in message ... 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 "Niek Otten" wrote in message ... Hi Paul, Check this tutorial: http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Kardon Coupé" wrote in message ... | 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. | | |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Looking for an Easy way to Achive a Result
"Kardon Coupé" wrote in message ... | 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,C1:D22,2,FALSE) -- Kind regards, Niek Otten Microsoft MVP - Excel | "Niek Otten" wrote in message | ... | Hi Paul, | | Check this tutorial: | | http://www.contextures.com/xlFunctions02.html | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Kardon Coupé" wrote in message | ... | | 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. | | | | | | | | |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Looking for an Easy way to Achive a Result
<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 "Kardon Coupé" wrote in message ... | 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? | | "Kardon Coupé" wrote in message | ... | 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 | | "Niek Otten" wrote in message | ... | Hi Paul, | | Check this tutorial: | | http://www.contextures.com/xlFunctions02.html | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Kardon Coupé" wrote in message | ... | | 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. | | | | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a quick/easy way to get excel to replace ALL forumulas the numerical result in one step? | Excel Discussion (Misc queries) | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |