Forum Discussion
Using IF for multiple values
Hey there! I'm afraid I got stuck at a point I need your expert advice. I want to use the function IF so as to state 3 different options and retrieve the value associated each one. Here it goes ...
You have too many parentheses:
=IF(W2="Local";Sheet3!B4;IF(W2="Ibérico";Sheet3!B5;IF(W2="Regional";Sheet3!B6;"")))
Another way is a lookup table:
The formula can then be
=IFERROR(VLOOKUP(W2; Sheet3!$A$4:$B$6; 2; FALSE); "")
If your Excel is in Spanish:
=SI.ERROR(BUSCARV(W2; Sheet3!$A$4:$B$6; 2; FALSE); "")