Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a cost code in one cell and discription in an other
I would like a formula that will let me place a number in one cell (its a
cost Code) then the next cell to show the discription of the cost code selected. I have it working using "if" but i have the problem of the dreaded "Seven" is there any way that i can increase the seven. Ihave been told that youcan group sets of seven giving each seven its own name . then bring the groups together but i do not know how its done. Or should i be looking at a differant formular. I have seen "vlookup" on your threads but i have no idea how to use it. Many thank for a super site Stuart |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a cost code in one cell and discription in an other
<I have seen "vlookup" ; You're on the right track!
Look at this tutorial: http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Stuart Morris" <Stuart wrote in message ... |I would like a formula that will let me place a number in one cell (its a | cost Code) then the next cell to show the discription of the cost code | selected. I have it working using "if" but i have the problem of the dreaded | "Seven" is there any way that i can increase the seven. Ihave been told that | youcan group sets of seven giving each seven its own name . then bring the | groups together but i do not know how its done. Or should i be looking at a | differant formular. I have seen "vlookup" on your threads but i have no idea | how to use it. | | Many thank for a super site Stuart |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a cost code in one cell and discription in an other
Also see this tutorial for creating a dropdown list of cost codes to choose
from. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Fri, 19 Oct 2007 22:26:10 +0200, "Niek Otten" wrote: <I have seen "vlookup" ; You're on the right track! Look at this tutorial: http://www.contextures.com/xlFunctions02.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type a cost code in one cell and discription in an other
It just getting better and better thanks verymuch
"Gord Dibben" wrote: Also see this tutorial for creating a dropdown list of cost codes to choose from. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Fri, 19 Oct 2007 22:26:10 +0200, "Niek Otten" wrote: <I have seen "vlookup" ; You're on the right track! Look at this tutorial: http://www.contextures.com/xlFunctions02.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to modify the code for different type of input? | Excel Worksheet Functions | |||
How to modify the code for different type of input? | Excel Discussion (Misc queries) | |||
when I type a zip code into a cell, only zeros show up. Help? | New Users to Excel | |||
Current Cost versus Original Cost | New Users to Excel | |||
[Q] Save As throws type mismatch error in control's code? | Excel Discussion (Misc queries) |