I have inherited a workbook and on some sheets the formula seems to work but in others the cell, Y11, shows #N/A.
The formula is: {=Lookup(2,1/(Max(0+Substitute(AH3:AH15&1,”\”, “1/“))=0+Substitute (AH3:AH15&1,”\”, “1/“)}
Could someone explain this to me and perhaps why some sheets are showing...