Setting Constants for categories

[mallen34]

I have a excel spread sheet with 250 categories, which need to be converted to a category id number. I want to update this every week and I am wondering if there is a way to define the category name to category id?

So is there a way to set a category name to = a number?

For example I want to convert the following names

Baby Doll = 100
Chemise = 198
Shoes = 200

Thanks

Sexy Fox Clothing

Find me on FACEBOOK
​

 

[mikerickson]

A VLOOKUP table will do what you want. In the example below, you have your name/category numbers in A1:B3, that can be changed when you want.
D1 holds the text "Chemise" and E1 the formula =VLOOKUP(D1,A1:B3,2,FALSE), which will return Chemise's value as you change the column B entries.

<table border=1 cellspacing=0>
<tr align="center" bgcolor=#A0A0A0><td width=25> <td width=25><b>A</b><td width=25><b>B</b><td width=25><b>C</b><td width=25><b>D</b><td width=25><b>E</b></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>1</b><td align="left" bgcolor=#FFFFFF>Baby Doll<td align="right" bgcolor=#FFFFFF>100<td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF>Chemise<td align="right" bgcolor=#FF99CC>198</tr>
<tr><td align="center" bgcolor=#A0A0A0><b>2</b><td align="left" bgcolor=#FFFFFF>Chemise<td align="right" bgcolor=#FFFFFF>198<td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF></tr>
<tr><td align="center" bgcolor=#A0A0A0><b>3</b><td align="left" bgcolor=#FFFFFF>Shoes<td align="right" bgcolor=#FFFFFF>200<td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF><td align="left" bgcolor=#FFFFFF></tr>
</table>