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

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

Type a cost code in one cell and discription in an other
 

Thank you very much you have been really helpfull

"Niek Otten" wrote:

<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

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

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