Forum Discussion

Y2135's avatar
Y2135
Copper Contributor
Sep 22, 2022

Excel if have problem.

Hi everyone, please help me, I don't know why my if so weird, for example I type: Cat     =IF(A3>="Cat",1, IF(A3>="Dog",2, IF(A3>="Bird",3,4))) Dog    =IF(A4>="Cat",1, IF(A4>="Dog",2, IF(A4>="Bird"...
excel
alannavarro's avatar
alannavarro
Iron Contributor
Sep 22, 2022
Sorry, forgot to explain that is sorting the strings in alphabetic order.
Y2135's avatar
Y2135
Copper Contributor
Sep 22, 2022
Ok, so how do I use if to type like this：
Cat 1
Dog 2
Bird 3
  • alannavarro's avatar
    alannavarro
    Iron Contributor
    Sep 22, 2022

    Y2135 I'm not sure how to do it with if function... What about using a vlookup?
    Attached is an example.

Resources