Forum Discussion
IFS FORMULA
Good Afternoon,
Could someone please help me with the following formula? The formula reads =IFS(a3="OUTSIDE GRID","OUTSIDE GRID",b3="G1DG","G1DG",c3="GSPECIAL","GSPECIAL") which works but i would like to further add to the formula by asking it to return the text that is in d3. Please note there are a variety of answers in d3 such as gdhl, dascher etc which is what i want it to return. i have tried adding some of the fields in like D2="DASCHER","DASCHER",D2="GDHL","GDHL" but just bringing up n/a. What can I do to resolve this error please?
Does it work if you confirm the formula by pressing Ctrl+Shift+Enter?
6 Replies
Does this do what you want? In E2:
=INDEX(A2:D2, MATCH(1, ISTEXT(A2:D2)*(A2:D2<>"N/A"), 0))
Fill down.
- Hi Hans Vogelaar, unfortunately it didn't work :(. It brought up #VALUE error message. Thank you for trying though 🙂
Strange - it works for me. See the attached workbook.
- Hi Hans Vogelaar unfortunately the formula didn't work it brought up #VALUE! error message. thanks for trying to help me 🙂
Does it work if you confirm the formula by pressing Ctrl+Shift+Enter?
