software

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: www.excelforum.com/member.php...oamp;userid=33815
View this thread: www.excelforum.com/showthread...hreadid=535889I 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)

quot;no0dlesquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; Ive just started working with excel sheets, literally today. I remember
gt; back in university I once made a worksheet in which numerical values
gt; (1,2,3,etc) corresponded to a text value.
gt;
gt; So 1= concept
gt; 2= production etc.
gt;
gt; I cant remember how to do this tho. If any1 could provide me with an
gt; answer to this, (very simple) question I would be most grateful.
gt;
gt; Thanks!
gt;
gt;
gt; --
gt; no0dles
gt; ------------------------------------------------------------------------
gt; no0dles's Profile:
www.excelforum.com/member.php...oamp;userid=33815
gt; View this thread: www.excelforum.com/showthread...hreadid=535889
gt;

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: www.excelforum.com/member.php...oamp;userid=33815
View this thread: www.excelforum.com/showthread...hreadid=535889You 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)

quot;no0dlesquot; gt; wrote in
message ...
gt;
gt; I need to make an overview sheet of all the current projects that are in
gt; our studio. One of the Columns would be Status.
gt;
gt; Each project goes through an x amount of phases. Phase 1 would be
gt; concept, 2 Mechanicals, 3 Presentation, etc.... Representing the
gt; status.
gt;
gt; I want to associate Numerical Values to text in such a way that I would
gt; type (e.g.) Project xx.xxxx 2 and instead of 2 Mechanicals would appear
gt; in the worksheet.
gt;
gt;
gt; --
gt; no0dles
gt; ------------------------------------------------------------------------
gt; no0dles's Profile:
www.excelforum.com/member.php...oamp;userid=33815
gt; View this thread: www.excelforum.com/showthread...hreadid=535889
gt;

Thanks for your reply Bob,

Could you point me to a VLOOKUP tutorial somewhere please? Thanks for
your help.--
no0dles
------------------------------------------------------------------------
no0dles's Profile: www.excelforum.com/member.php...oamp;userid=33815
View this thread: www.excelforum.com/showthread...hreadid=535889www.contextures.com/xlFunctions02.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;no0dlesquot; gt; wrote in
message ...
gt;
gt; Thanks for your reply Bob,
gt;
gt; Could you point me to a VLOOKUP tutorial somewhere please? Thanks for
gt; your help.
gt;
gt;
gt; --
gt; no0dles
gt; ------------------------------------------------------------------------
gt; no0dles's Profile:
www.excelforum.com/member.php...oamp;userid=33815
gt; View this thread: www.excelforum.com/showthread...hreadid=535889
gt;

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: www.excelforum.com/member.php...oamp;userid=33815
View this thread: www.excelforum.com/showthread...hreadid=535889Sure, just use that cell in the formula

=VLOOKUP(C4,...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;no0dlesquot; gt; wrote in
message ...
gt;
gt; Thanks Bob,
gt;
gt; I got the VLOOKUP formula to work. However, I still have a question. Is
gt; there a way to automatically make the reference look to the the cell
gt; directly left of the column (Say the Code is entered in column C, I
gt; want to the Text to appear in column D. So for the reference for D4, it
gt; should automatically look at C4, D5, ref C5, etc.) Is there a way to get
gt; this done?
gt;
gt; Thanks a lot!
gt;
gt;
gt; --
gt; no0dles
gt; ------------------------------------------------------------------------
gt; no0dles's Profile:
www.excelforum.com/member.php...oamp;userid=33815
gt; View this thread: www.excelforum.com/showthread...hreadid=535889
gt;