Hi Brent,

If you are only wanting results that are under a certain amount you can use:

=if(VLOOKUP(D26,'Sales
Averages'!$A$4:$M$5000,4,FALSE)A1,0,VLOOKUP(D26,' Sales
Averages'!$A$4:$M$5000,4,FALSE))

I placed the "upper limit" in cell A1.

If you are wanting ALL values under that amount you should use a filter.

Squeaky.



"Brent" wrote:

Hi,

I have created the following equation using VLOOKUP...

=VLOOKUP(D26,'Sales Averages'!$A$4:$M$5000,4,FALSE)

The result varies depends on my data, but I would like any result that is $0
to equal "***"

Does anyone have any ideas?

Thanks so much for your help!!