CODEWITHSUNDEEP
excelif-statement
Gavin C
Gavin C

Reputation: 3

Use of multiple IF conditions in Excel

I'm trying to get a cell to pick a cell of data from a table using IF (Excel 2010, can't do IFS), but when I try to nest more than 2 IF, it returns a "too many arguments" error. Formula at this point:

=IF(B11="Humain",VLOOKUP(COO,Fonctions!A88:M110,2,FALSE),IF(OR(B11="Hybride Naturel",B11="Géno-Hybride"),VLOOKUP(COO,Fonctions!A88:M110,3,FALSE)))

Where am I doing it wrong? :/

Upvotes: 0

Views: 99

Answers (1)

Gareth
Gareth

Reputation: 5243

You're missing a final comma should the second IF condition return false. Update your formula like so:

=IF(B11="Humain",VLOOKUP(COO,Fonctions!A88:M110,2,FALSE),IF(OR(B11="Hybride Naturel",B11="Géno-Hybride"),VLOOKUP(COO,Fonctions!A88:M110,3,FALSE),"N/A"))

Notice the N/A that will be produced should both IF statements do not yield any results.

Upvotes: 1

Related Questions