if(len(vlookup with error

[gabdid]

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!

 

[gabdid]

Hi again, thought maybe you could work your magic again. i tried the same formula in another document where i have the info on the same sheet,

=LET(v;VLOOKUP(C3;$A$2:$B$200;2;0);IF(C3="";"";IF(v="";"";v)))

In A column is mixed with no formulas and =IF(ISBLANK($A$52);"";$A$52-7)

However i get N/A in all the cells again with no date.

Is there something i need to tweek?

 

[Fluff]

What is in col C?

 

[gabdid]

Sorry i had it in white font. its the date thats its based on.

 

[Fluff]

None of those cells are blank.

 

[gabdid]

where its taking the info from, in column A there are some cells blank. So the vlookup should base the info from C column and the info is in A-B column. in the A column i have some blank cells, some with a formula (isblank) and some with just the date without a formula. and in column I i dont want the N/A to show if there is no info or that date. If that makes sense?

 

[Fluff]

But you originally said if the vlookup returned #N/A you wanted to see that.

 

[gabdid]

Ah then sorry if i wasn't clear. i want it to be blank and not show the N/A in column I. Just like i did in the last document and there this formula worked but it doesnt work in this document.

=LET(v;VLOOKUP(C3;$A$2:$B$200;2;0);IF(C3="";"";IF(v="";"";v)))

 

[Fluff]

That formula is doing exactly what you originally asked for. If C3 is blank or col B is blank then return "" otherwise return the result of the vlookup including #N/A.
If you now want something different you will need to explain exactly what you do want.

 

[gabdid]

I just want it to be blank in column I and not show N/A

 

[gabdid]

I just want it to be blank in column I and not show N/A

If there is no info to get from that date.