CAN SOMEONE HELP ME THIS FORMULA
Ii HAVE THIS FORMULA
=ISNA(MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0)),"N/A",INDEX(Vin_Lookup,MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0),3))
I WAND TO ADD TO THIS FORMULA AN "IF" AND "OR" STATEMENT (IF F14 IS = TO 1, OR F15 = 2) THAN IS SHOULD =ISNA(MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0)),"N/A",INDEX(Vin_Lookup,MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0),3))
I GUEST IT SHOULD BE SOMETHING LIKE THIS
=IF(OR(F14=1,F15=2),(ISNA(MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0)),"N/A",(OR(F14=1,F15=2),INDEX(Vin_Lookup,MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0),3))
Bookmarks