If statement with a vlookup

[PHIL.Pearce84]

Hi All

I want to perform a vlookup but only if a specified cell is greater than zero, how can I do this?

Thanks

 

[VoG]

Try like this

=IF(A1>0,VLOOKUP(A1,B1:C100,2,FALSE),"")

 

[jeffreybrown]

Try something like....

=If(A1>0,Vlookup(A1,D1:F1000,2,0),"")

 

[PHIL.Pearce84]

Perfect thank you, I missed out the open bracket