Compare and replace values

[Bastet]

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

 

[papou]

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

HTH
Cordially
Pascal

 

[Bastet]

Great, thanks

Is there a way to replace CHOOSE(A1, *"Toto","Tata","Titi" *) b
something like CHOOSE(A1, *Name of a column or an area*) ?

Because my list of choice can be quite long and change from a survey t
an other

 

[papou]

With YourList named range referring to, well, your list:
=INDEX(YourList,A1)

Cordially
Pascal

 

[Bastet]

Many thanks for your help. It's exaclty what I was looking for