mercredi 22 janvier 2020

Combining IF Matching Statements

Is there an easier way to put these two formulas together? I'm struggling. My two Formulas are

IF(MATCH(BASETRACKER!B2,'Code List Values'!V:V,0),"Reassign"))

and

=IF(F2="","",IF(MATCH(BASETRACKER!F2,'Code List Values'!E:E,0),"PRIVATE"))

Any help would be great!

Aucun commentaire:

Enregistrer un commentaire