Help in formating cells
 

I'm running into a brain buster for my simple mind.
I want to be able to put an number into a cell, but have a word show
instead. Is this possible? For example: in Cell A1, I will type
"000053", but would like "Frontier" to show. Any help will be greatly
appreciated, for this might show my CEO that I might know something
they don't!


--
ExcelNubee
------------------------------------------------------------------------
ExcelNubee's Profile: http://www.excelforum.com/member.php...o&userid=32719
View this thread: http://www.excelforum.com/showthread...hreadid=525547

Help in formating cells
 

Make a table with the numbers in one column then another column with what
the numbers represent
put them somewhere of the visible area, in for instance numbers in Y1:Y50
and text in Z1:Z50

then use


=IF(A1="","",VLOOKUP(A1,Y1:Z50,2,0))

if you put that formula in C2 then type the number in A1

note that leading zeros does not matter if the numbers are really numbers,
however if you format Y1:Y50 and A1 as text you can use leading zeros and
they will have an impact
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"ExcelNubee" wrote
in message ...

I'm running into a brain buster for my simple mind.
I want to be able to put an number into a cell, but have a word show
instead. Is this possible? For example: in Cell A1, I will type
"000053", but would like "Frontier" to show. Any help will be greatly
appreciated, for this might show my CEO that I might know something
they don't!


--
ExcelNubee
------------------------------------------------------------------------
ExcelNubee's Profile:
http://www.excelforum.com/member.php...o&userid=32719
View this thread: http://www.excelforum.com/showthread...hreadid=525547