I have the following formula in my worksheet that is not working:
=IF(AND('FY03 Booking Detail'!$F$24:$F$65536=D22,'FY03 Booking Detail'!$C$18:$C$65536=C22),"Match","None")
I have an two columns on two worksheets with the same information - as evidenced by the formula.
The "FY03 Booking Detail" is the correct worksheet, the active sheet is the copy.
The return value I am getting why I run this formula is "None". In other words, the And, If then formula is not running properly because when I check the master sheet, the Sales Order is there.
What can I do to improve the formula?