Numerical Value to text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

no0dles - 25 Apr 2006 11:17 GMT

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!

Signature

no0dles

Reply to this Message

Bob Phillips - 25 Apr 2006 11:43 GMT

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?

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks!

Reply to this Message

no0dles - 25 Apr 2006 12:37 GMT

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.

Signature

no0dles

Reply to this Message

Bob Phillips - 25 Apr 2006 13:21 GMT

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)

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> I need to make an overview sheet of all the current projects that are in
> our studio. One of the Columns would be Status.
[quoted text clipped - 6 lines]
> type (e.g.) Project xx.xxxx 2 and instead of 2 Mechanicals would appear
> in the worksheet.

Reply to this Message

no0dles - 25 Apr 2006 13:30 GMT

Thanks for your reply Bob,

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

Reply to this Message

Bob Phillips - 25 Apr 2006 13:39 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

Reply to this Message

no0dles - 25 Apr 2006 14:31 GMT

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!

Signature

no0dles

Reply to this Message

Bob Phillips - 25 Apr 2006 15:24 GMT

Sure, just use that cell in the formula

=VLOOKUP(C4,...

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Thanks Bob,
>
[quoted text clipped - 6 lines]
>
> Thanks a lot!

Reply to this Message