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!

 

[Fluff]

Ok try

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

 

[gabdid]

i get this error message then

 

[Fluff]

You need to change the comma

 

[gabdid]

Haha, omg im so blind! thank a million again!!!!

 

[Fluff]

Glad to help & thanks for the feedback.