Forum Discussion
COMBINE THESE FORMULAS
=IF(H43="ALIAS ID 1", IF(O43>='SHEET2'!$G$602,"NSF","") =IF(H43="ALIAS ID 2", IF(O43>='SHEET2'!$G$707,"NSF","") =IF(H43="ALIAS ID 3", IF(O43>='SHEET2'!$G$812,"NSF","") =IF(H43="ALIAS ID 4", IF(...
IF(OR(AND(H42="ALIAS ID 1", O43>='SHEET2'!$G$602), AND(H42="ALIAS ID 2", O43>='SHEET2'!$G$707), AND(H42="ALIAS ID 3", O43>='SHEET2'!$G$812), AND(H42="ALIAS ID 4", O43>='SHEET2'!$G$1132), AND(H42="ALIAS ID 5", O43>='SHEET2'!$G$1562), AND(H42="ALIAS ID 6", O43>='SHEET2'!$G$1782)), "NSF", "")
IF(OR(AND(H42="ALIAS ID 1", O43>='SHEET2'!$G$602), AND(H42="ALIAS ID 2", O43>='SHEET2'!$G$707), AND(H42="ALIAS ID 3", O43>='SHEET2'!$G$812), AND(H42="ALIAS ID 4", O43>='SHEET2'!$G$1132), AND(H42="ALIAS ID 5", O43>='SHEET2'!$G$1562), AND(H42="ALIAS ID 6", O43>='SHEET2'!$G$1782)), "NSF", "")
Thank you Hans. after so many days I finally solved this, thanks to you! ❤️ Thank you so much!
