Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,041
- Office Version
- 365
- Platform
- Windows
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 the #N/A?
Many thanks.
Mel
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 the #N/A?
Many thanks.
Mel