Forum Discussion

Copper Contributor

Jun 16, 2022

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 ...

excel

Formulas and Functions

OliverScheurich
Jun 16, 2022
FamePrincess17
=IF(A6="907.643-13",A2,IF(A6="907.645-13",A3,IF(A6="907.647-13",A4,"")))
Maybe with this formula.

PeterBartholomew1

Silver Contributor

Jun 16, 2022

FamePrincess17

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,
  "")