mardi 11 février 2020

If statement from different sheet base on two cell

I have a 2 sheets,Summary & Remarks and I'm trying to create a REMARKS ERROR base on summary sheet data.

Example. In Sheet Summary if both area01 & area01 has no value the REMARKS ERROR! will appear in Sheet REMARKS. If one area does not have area code the error remarks will not appear

Can someone help me, please? Please see attached Google sheet

REMARKS_SHEET

Aucun commentaire:

Enregistrer un commentaire