Forum Discussion
Solved
Multiple IF functions in one cell
I cannot figure out how to create multiple IF functions in one cell. I need for one cell to show A2, A3, or A4 based off if the cell before has 907.643-13(A2), 907.645-13(A3), or 907.647-13(A4). How can I do this? Is it not an IF function?
=IF(A6="907.643-13",A2,IF(A6="907.645-13",A3,IF(A6="907.647-13",A4,"")))Maybe with this formula.
3 Replies
365 users have options that do not required nested formulas.
= IFS(A6="907.643-13",A2, A6="907.645-13",A3, A6="907.647-13",A4, 1,"") = SWITCH(A6, "907.643-13",A2, "907.645-13",A3, "907.647-13",A4, "")or switching tack
= XLOOKUP( A6, {"907.643-13";"907.645-13";"907.647-13"}, A2:A4, "")=IF(A6="907.643-13",A2,IF(A6="907.645-13",A3,IF(A6="907.647-13",A4,"")))Maybe with this formula.
- OH MY GOODNESS THAT WORKED!!! I did something similar to this earlier but I must've missed something.
#GENIUS lol
