I have a data base that exports a numerical value to a specified column. Numbers are typically 1,2,3,4,5 and I would like to have a formula that will input text each time it sees one of those numbers. for example If 1 is imported then the 1 should equal apple, if 2 then orange, etc.

I also understand there is a limitation on the number of actions. I have another that has close to 30 numbers I need to associate to text.

anyone done this before.

I would appreciate it.

Thanks
Mark