I am having trouble getting in a isblank in my formula. its a vlookup on a isblank cell, i also need the vlookup to have the error but i dont want the N/A if the cell its getting the information from is blank;
First part: =IF(ISBLANK(E49);"";E34+7) - works fine
Second part: =IF(LEN(VLOOKUP(E32;Sheet1!U2:W865;3;0))=0;"";VLOOKUP(E32;Sheet1!U2:W865;3;0)) - this is where i need to also add make it blank if cell E32 is blank so i dont get the N/A
Can someone help me?
Thanks in advance!
First part: =IF(ISBLANK(E49);"";E34+7) - works fine
Second part: =IF(LEN(VLOOKUP(E32;Sheet1!U2:W865;3;0))=0;"";VLOOKUP(E32;Sheet1!U2:W865;3;0)) - this is where i need to also add make it blank if cell E32 is blank so i dont get the N/A
Can someone help me?
Thanks in advance!