Vlookup help

[RattlingCarp3048]

Hello, newbie here to the platform! I have a pretty decent understanding with excel but I cant seem to figure this one out. Any help is appreciated!!

I need to create a formula that says: if the vlookup is 0 or #N/A return blank, otherwise return the vlookup data.

=iferror(if(len(vlookup(date string))=0," ",vlookup(data string))," ")

I tried this one below but at the end when I click enter it just leaves the formula string in the cell. It doesn't actually work the formula. Any thoughts?

 

[etaf]

the length of the string will not be blank
if you want zero or an error to be blank

=IF ( OR( Iserror(vlookup), vlookup = 0 ) , "" , vlookup )
Also you are using " " , which is NOT a blank cell - its putting a space
"" is a blank cell

 

[RattlingCarp3048]

Tried but no luck. When I click enter the formula remains in the cell. See pictures.

=if(or(iserror(vlookup(U2,'Yesterday's Log'!U:V,2,0),vlookup(U2,'Yesterday's Log'!U:V,2,0)=0),"",vlookup(U2,'Yesterday's Log'!U:V,2,0)

No spaces anywhere in the entire string

 

[Fluff]

When I click enter the formula remains in the cell

Check that the cell is not formatted as text.

 

[RattlingCarp3048]

Check that the cell is not formatted as text.

Lol now it says too many arguments for the function.

 

[Fluff]

Try

=IF(IFERROR(VLOOKUP(U2,'Yesterday''s Log'!U:V,2,0),"")="","",VLOOKUP(U2,'Yesterday''s Log'!U:V,2,0))

 

[RattlingCarp3048]

Try

=IF(IFERROR(VLOOKUP(U2,'Yesterday''s Log'!U:V,2,0),"")="","",VLOOKUP(U2,'Yesterday''s Log'!U:V,2,0))

Now it says #N/A and 0.

 

[Fluff]

That formula will not return #N/A & will only return 0 if that is what is in col V

 

[RattlingCarp3048]

That formula will not return #N/A & will only return 0 if that is what is in col V

Actually it worked!! It was a typo the first time ?? thank you so much!!

 

[Fluff]

Glad we could help & thanks for the feedback.