Hello,
I need help fixing the below formula:
=IF(LEN(B11=7)+LEN(B11=5),IF(C13="N/A","N/A",(VLOOKUP(LEFT(B11,SEARCH("S",B11)-1),'Adders calculation'!A:Y,3,0))))
What I need this formula to do is check the length of cell B11, if it's 7 or 5, it should exclude S character and do a VLOOKUP. If the length is different from 7 or 5, it should just do a VLOOKUP. In both cases, if C13 is N/A, result should be N/A.
It works for cell contents with length 5 or 7, but all other lengths it doesn't go to the second if and just gives me #VALUE! as return value.
I appreciate any help I can get.
I need help fixing the below formula:
=IF(LEN(B11=7)+LEN(B11=5),IF(C13="N/A","N/A",(VLOOKUP(LEFT(B11,SEARCH("S",B11)-1),'Adders calculation'!A:Y,3,0))))
What I need this formula to do is check the length of cell B11, if it's 7 or 5, it should exclude S character and do a VLOOKUP. If the length is different from 7 or 5, it should just do a VLOOKUP. In both cases, if C13 is N/A, result should be N/A.
It works for cell contents with length 5 or 7, but all other lengths it doesn't go to the second if and just gives me #VALUE! as return value.
I appreciate any help I can get.