Hi,

Ive just started working with excel sheets, literally today. I remember
back in university I once made a worksheet in which numerical values
(1,2,3,etc) corresponded to a text value.

So 1= concept
2= production etc.

I cant remember how to do this tho. If any1 could provide me with an
answer to this, (very simple) question I would be most grateful.

Thanks!


--
no0dles
------------------------------------------------------------------------
no0dles's Profile: http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

I think you need to explain how you would implement that.

You can easily create a table of ids and associated values, but that in
itself does nothing. What would you do with it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"no0dles" wrote in
message ...

Hi,

Ive just started working with excel sheets, literally today. I remember
back in university I once made a worksheet in which numerical values
(1,2,3,etc) corresponded to a text value.

So 1= concept
2= production etc.

I cant remember how to do this tho. If any1 could provide me with an
answer to this, (very simple) question I would be most grateful.

Thanks!


--
no0dles
------------------------------------------------------------------------
no0dles's Profile:
http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

I need to make an overview sheet of all the current projects that are in
our studio. One of the Columns would be Status.

Each project goes through an x amount of phases. Phase 1 would be
concept, 2 Mechanicals, 3 Presentation, etc.... Representing the
status.

I want to associate Numerical Values to text in such a way that I would
type (e.g.) Project xx.xxxx 2 and instead of 2 Mechanicals would appear
in the worksheet.


--
no0dles
------------------------------------------------------------------------
no0dles's Profile: http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

You can get that with a simple VLOOKUP

=VLOOKUP(C2,$M$1:$N$20,2,False)

where C2 is the number, and M1:N20 is the table of ids and values)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"no0dles" wrote in
message ...

I need to make an overview sheet of all the current projects that are in
our studio. One of the Columns would be Status.

Each project goes through an x amount of phases. Phase 1 would be
concept, 2 Mechanicals, 3 Presentation, etc.... Representing the
status.

I want to associate Numerical Values to text in such a way that I would
type (e.g.) Project xx.xxxx 2 and instead of 2 Mechanicals would appear
in the worksheet.


--
no0dles
------------------------------------------------------------------------
no0dles's Profile:
http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

Thanks for your reply Bob,

Could you point me to a VLOOKUP tutorial somewhere please? Thanks for
your help.


--
no0dles
------------------------------------------------------------------------
no0dles's Profile: http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"no0dles" wrote in
message ...

Thanks for your reply Bob,

Could you point me to a VLOOKUP tutorial somewhere please? Thanks for
your help.


--
no0dles
------------------------------------------------------------------------
no0dles's Profile:
http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

Thanks Bob,

I got the VLOOKUP formula to work. However, I still have a question. Is
there a way to automatically make the reference look to the the cell
directly left of the column (Say the Code is entered in column C, I
want to the Text to appear in column D. So for the reference for D4, it
should automatically look at C4, D5, ref C5, etc.) Is there a way to get
this done?

Thanks a lot!


--
no0dles
------------------------------------------------------------------------
no0dles's Profile: http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889

Sure, just use that cell in the formula

=VLOOKUP(C4,...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"no0dles" wrote in
message ...

Thanks Bob,

I got the VLOOKUP formula to work. However, I still have a question. Is
there a way to automatically make the reference look to the the cell
directly left of the column (Say the Code is entered in column C, I
want to the Text to appear in column D. So for the reference for D4, it
should automatically look at C4, D5, ref C5, etc.) Is there a way to get
this done?

Thanks a lot!


--
no0dles
------------------------------------------------------------------------
no0dles's Profile:
http://www.excelforum.com/member.php...o&userid=33815
View this thread: http://www.excelforum.com/showthread...hreadid=535889