Posted to microsoft.public.excel.worksheet.functions
|
|
Excel Problem
Take a look at these links:
http://www.contextures.com/xlFunctions03.html
http://www.contextures.com/xlFunctions02.html
Regards,
Ryan---
--
RyGuy
"Mike H" wrote:
Maybe
=VLOOKUP(C1,$A$1:$B$17,2,FALSE)
Wher C1 is the Code No and your table is in A1 - B17
Mike
"Meshah" wrote:
My problem is that i have a code no in 001 , 002 003 continue to 016
now i want to change the 001 to "Monti", 002 to "Nur" and 003 to "KG1"
and so on.
i want to type the number and the result shown me in text like Monti ,
Nursary and so on.
ClasCode Change into
000 Mont
001 Nur
002 KG 1
003 KG 2
004 I
005 II
006 III
007 IV
008 V
009 VI
010 VII
011 VIII
012 IX SCI
013 IX GN
014 X SCI
015 X GN
016 X COMP
|