Formula in Excel

  • Thread starter Thread starter Valcon
  • Start date Start date
V

Valcon

I have a colum that has categories that are abbreviated that i need a
formula to convert the abbrevation to a word
for example IF the cell has CS than it should change to Case, IF the
cell has AC then it should change to Accessory.
 
I have a colum that has categories that are abbreviated that i need a
formula to convert the abbrevation to a word
for example IF the cell has CS than it should change to Case, IF the
cell has AC then it should change to Accessory.
Click to expand...


=IF(E3="CS","Case",IF(E3="AC","Accessory",""))

i came up with this but i need more then 7 nested formulas Need to
know the Vlookup formula for this.
 
hello,

Build a table somewhere in your sheet like this:
example:
column AA column AB
Row 1 CS Case
Row 2 AC Accessory
.....and so on.
Say your table is in range AA1 to AB10

I assumed your categories to convert are in column A from A2 to ...

Then enter this formula in B2 and drag down the formula:
=INDEX($AB$1:$AB$10,MATCH(A2,$AA$1:$AA$10,0))


"Valcon" <[email protected]> a écrit dans le message de groupe de
discussion :
(e-mail address removed)...
 
Make a two column table somewhere on your sheet.
The first column with the abbreviations and the second column with the words.

The help file explains Vlookup and provides examples...
"VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)"

So if your table was in A1:B100 the formula could look like...
= Vlookup("AC",A1:B100 ,2,False)
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasForXL

..
..
..

"Valcon" <[email protected]>
wrote in message
I have a colum that has categories that are abbreviated that i need a
formula to convert the abbrevation to a word
for example IF the cell has CS than it should change to Case, IF the
cell has AC then it should change to Accessory.
Click to expand...


=IF(E3="CS","Case",IF(E3="AC","Accessory",""))

i came up with this but i need more then 7 nested formulas Need to
know the Vlookup formula for this.
 
Back
Top