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?

 

[RattlingCarp3048]

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

Question: I applied the same formula to two additional columns W and X. Updated the vlookup. It worked for column W but now not column X. Formatted X for general text. Any thoughts?

vlookup(U2,'Yesterday's Log'!U:X,4,0)

 

[RattlingCarp3048]

Question: I applied the same formula to two additional columns W and X. Updated the vlookup. It worked for column W but now not column X. Formatted X for general text. Any thoughts?

vlookup(U2,'Yesterday's Log'!U:X,4,0)

Typo again ? too much coffee lol