Numerical Value to text

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!

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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.

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"no0dles" <[email protected]> wrote in
message news:[email protected]...
>
> 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!

Sure, just use that cell in the formula

=VLOOKUP(C4,...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"no0dles" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>