Forum Discussion
Excel formula help
I am trying to figure out a formula that would allow me to create a result like this... In Column P, I would like it to automatically generate a text based on numbers entered in column N. For ex...
Variants for P2 could be
=IFERROR(CHOOSE($N2,"Diamond","Mounting","Gemstone"),"")
or
=IFNA(LOOKUP($N2,{1,2,3,3.01},{"Diamond","Mounting","Gemstone",""}),"")
or
=IFERROR(IF($N2<1,NA(),INDEX({"Diamond";"Mounting";"Gemstone"},$N2)),"")
copied down till end of the range. Text constants could be substituted by cells range