Hello, Excel Gurus:
Please help on this one!!
I have six columns of data (A1:F1). I’m trying to use the IFS function in G1:L1.
1. I entered in Column G1:L1 the IFS function: =IFS(A1=$O$2:$O$8,$O$1,A1=$P$2:$P$8,$P$1,A1=$Q$2:$Q$8,$Q$1,A1=$R$2:$R$6,$R$1)
2. I have a named range in O2:O8 with the number 1 in O1.
3. I have a named range in P2:P8 with the number 2 in P1.
4. I have a named range in Q2:Q8 with the number 3 in Q1.
5. I have a named range in R2:8R with the number 4 in R1.
I’m trying to get the formula to look in those (4) named range’s and if it’s in that individual range put the number of that range that is in O1:R1 into that cell. In my example worksheet it seems sometimes it work.
Please Help when you can. Thanks, in advanced
Bookmarks