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? :/
Aucun commentaire:
Enregistrer un commentaire