Numerical Value to text

[no0dles]

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!

 

[Bob Phillips]

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]

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.

 

[Bob Phillips]

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]

Thanks for your reply Bob,

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[no0dles]

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!

 

[Bob Phillips]

Sure, just use that cell in the formula

=VLOOKUP(C4,...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)