Issue:if statement problem

[step_one]

Hi

Having some issue trying to place the logic in my if statement

=IF(OR(D2="",D2="0"),"",VLOOKUP(D2,'All stores'!$C$10:$S$954,17,FALSE))


basically, i would like to further show,

if the vlookup = "" then show ""

so basically, if the vlookup answer is a blank, show a blank; it is currently showing a 0 instead.

thx you so much!

[edvwvw]

=IF(D2="","",IF(D2=0,"",VLOOKUP(D2,'All stores'!$C$10:$S$954,17,FALSE)))

edvwvw

[jw01]

try placing T, before vlookup