Hello,

Here is my problem. I've got a set of values in one excel sheet (th
results of a survey), some columns represents the results of a choic
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 tex
value toto, tata, titi. And I can't change anything in the form tha
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 th
list of my checkbox choice (one column with the text, one column wit
the corresponding number).


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

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

Thanks.


Baste

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