Forum Discussion
cherieb
Jun 28, 2019Copper Contributor
Using IF or IFS function with named ranges
I'm trying to write a formula that will populate a cell based on the information in another cell. Stated one way: "If the value in cell A2 equals the name of any of the people in this named rang...
Twifoo
Jun 28, 2019Silver Contributor
Try this:
=IF(COUNTIF(SME,A2),”SME”,
IF(COUNTIF(L3_,A2),”L3”,
IF(COUNTIF(L2_,A2),”L2”,
“Not Found”)))
=IF(COUNTIF(SME,A2),”SME”,
IF(COUNTIF(L3_,A2),”L3”,
IF(COUNTIF(L2_,A2),”L2”,
“Not Found”)))