Hi Bastet
=CHOOSE(A1,"Toto","Tata","Titi")

HTH
Cordially
Pascal

"Bastet " a écrit dans le message de
...
Hello,

Here is my problem. I've got a set of values in one excel sheet (the
results of a survey), some columns represents the results of a choice
in a list of checkbox.

Here is my checkbox list :

1. Toto
2. Tata
3. Titi

My result file give me the position number 1, 2, 3 instead of the text
value toto, tata, titi. And I can't change anything in the form that
give this result.

So, what I want to do, is to replace the 1, 2, 3 by their text value,
in excel.

I've got a sheet with my imported data results, and a sheet with the
list of my checkbox choice (one column with the text, one column with
the corresponding number).


How can I parse my results sheet, to replace the numbers with the
correponding text ? Any function doing that ? Or macro ?

Ok, it's working with a long "IF" function, but it's not reusable at
all if I change the number of checkbox choice (for an other survey,
with the same kind of template), etc.

Thanks.


Bastet


---
Message posted from http://www.ExcelForum.com/