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]

Hi & welcome to MrExcel
How about =let(v,VLOOKUP(E32;Sheet1!U2:W865;3;0),if(or(E32="",v=""),"",v))

 

[gabdid]

Thanks!!

I tried that now and i get the error message "The first argument of LET must be a valid name" - sorry i have never used LET so not sure what it means...

 

[Fluff]

Swap the commas for semi-colons.

 

[gabdid]

AWESOME - THANKS SO MUCH!!!!!

 

[gabdid]

Actually i spoke to soon - i still get the N/A instead of blank in the cell. it works when the cell is not blank but when it is i get the N/A

 

[gabdid]

 

[Fluff]

Ok, how about

=LET(v;VLOOKUP(E32;Sheet1!U2:W865;3;0);IF(E32="";"";IF(v="";"";v)))

 

[gabdid]

Magic - now it works, thanks a million - have a great rest of the day

 

[Fluff]

You're welcome & thanks for the feedback.