=IF((INDEX(InsertDataHERE!A45:AB45,MATCH(A45,A45,F ALSE),6))=(INDEX(ReferenceData!49:49,MATCH(A45,A45 ,FALSE),12)),"OK","Review")
Hi guys the above formular works great, however I need to add to this at the start asking if INDEX(InsertDataHERE!A45:AB45,MATCH(A45,A45,FALSE) ,6 Is Null then "Review" and then carry on with the above statement. I have tried al lsorts to no avail.
Hi guys the above formular works great, however I need to add to this at the start asking if INDEX(InsertDataHERE!A45:AB45,MATCH(A45,A45,FALSE) ,6 Is Null then "Review" and then carry on with the above statement. I have tried al lsorts to no avail.
Null Value in INDEX MATCH
0 commentaires:
Enregistrer un commentaire