number codes to text

[Whatnote]

Hi there,

is there a way to convert number code to text?

eg

7 = Fire damage
21 = Water damage
43 = Impact damage

At the moment all the column has is numbers, ideally I'd like to convert them to the sentence?

Look forward to hearing from you.

Yours

Daniel.

[quekbc]

If you have a table stating what each number codes represent, you can then use INDEX and MATCH functions to convert those numbers into the relevant texts in a separate cell. See attached for an example.

[Tony Valko]

Create a 2 column table with the number code in the left column and the corresponding text string in the right column...

Data Range

	A	B	C	D	E
1	Code	Type	------	Code	Type
2	21	Water damage		7	Fire damage
3				21	Water damage
4				43	Impact damage

This formula entered in B2:

=VLOOKUP(A2,D$2:E$4,2,0)