IF statement for recoding variables

[WashingtonDC]

I have a list of ICD-10 codes that I would like to recode into diagnosis categories- this would be a one to many relationship.

For example I have: And I want:
98745 Flu
96458 Pneumonia
98462 Flu
95643 Pneumonia
97542 Heart Disease



There could be upwards of 20 ICD-10 codes that correspond to a single diagnosis category, with a total of 6 possible diagnoses. Is this possible to do with an IF statement?

 

[Special-K99]

Just create a table with two columns the 5 digit code and the description.
Then just do

=VLOOKUP(Sheet1!A1,Sheet2!A$1:B$20,2,0)

where Sheet1!A1 is your lookup code and Sheet2!A$1:B$20 is your table.
If you extend the range to B$1000 then you can add further codes without having to change the formula.

 

[WashingtonDC]

Thanks! Is there a way to add an "other" category if the entered values fall outside the range I've pre selected?