Jack

The other option might be to use a Lookup.

you could have another sheet "YourOtherSheet" with a list of the numbers and
their respective responses.

A B

1 Your Message#1
2 Your Message#2
3 Your Message#3

Etc

Back to your Main sheet

In Cell B1

=Vlookup(A1,YourOtherSheetName!A1:B25,2,False)

Not sure if you will need to copy the formula down to other cells below, but
if you do, then do as required.

HTH
Mick