Converting a number in one column to a word in another column
Hi all, This is probably covered elsewhere but I couldn't find it. I'd like to make a formula that will give a specific word for a given value in a separate column. See below:ColumnValueWord13Orange23Orange34Red45GreenAny tips on how I can accomplish this? Thanks! KH