Multiple IF functions in one cell

[FamePrincess17]

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?

[#2 · Accepted solution]

@FamePrincess17 

=IF(A6="907.643-13",A2,IF(A6="907.645-13",A3,IF(A6="907.647-13",A4,"")))

Maybe with this formula.

 

[#3]

OH MY GOODNESS THAT WORKED!!! I did something similar to this earlier but I must've missed something.
#GENIUS lol

[#4]

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