mercredi 27 juillet 2016

IF STATEMENT to return on column Criteria

please forgive what I am about to write its the only way i know how to get across what I am trying to achieve. I believe the picture will help. The IF statement I would love to have would work like this. IF column O contains "TRUE" any where in its range and column P contains "TRUE" anywhere in its range and the customer id in column d is identical for both return me "BINGO" Is this possible to achieve and as always any help is greatly appreciated.

enter image description here

Aucun commentaire:

Enregistrer un commentaire