Hi,
I'm having an issue returning the 'Expected Title Date' for one of our projects - Stage 3 of the development has been broken into sub-stages (3A, 3B & 3C).
The current formula in use is: =IF((VLOOKUP(B1,Input!H21:V27,'Internal Reports'!B2+4)-14)<0,"Titled",VLOOKUP(B1,Input!H21:V27,'Internal Reports'!B2+4)-"14"). This is working fine for projects and stages that just have a numeric value (I.e. '1', '2', etc.); however, I'm getting the '#VALUE!' error once I use a data validation list to navigate to this particular project with sub-staging.
I understand this is because the formula is attempting to add 3'A'+4 - in the formula above, where can I insert the ISNUMBER function to have it dismiss the lettering? Or is there another function to be used?
I can provide further explanation of the context and worksheets/data at play if need be. Hoping it's just the particular placement of the ISNUMBER function as opposed to rewriting the entire formula.
Thanks.
Bookmarks