Lookup Problem

[Scott]

Hello,

I need some help with a lookup formula. I have a list of some duplicate
customer data but I want to answer the question "Give the sales amount for
the customer if it's greater than zero."


Customer Sales
Microsoft 0
Microsoft 100
Microsoft 100
Microsoft