Why is this formula not working? #2

[reglook0736]

this is the same issue as #2 earlier ...

=IF(D$18>0,VLOOKUP(D$6,Data,41,FALSE),"")

the result of this is ALWAYS the result of the lookup ... I only want it to return the lookup value if the result of d18 is greater than 0.

thanks for the help!!!

[daffodil11]

Is D18 actually Null or <=0, or is an empty string such as ""?

You didn't attach a sample of your work, so it's difficult to tell what you are working with.

Perhaps:

=IF(AND(D$18>0,D$18<>""),VLOOKUP(D$6,Data,41,FALSE),"")

Also, I'd recommend reviewing the Forum Rules. Your thread title is a little ambiguous.

[daffodil11]

Strange double post...