Try this:

=IF(VLOOKUP(D26,'Sales
Averages'!$A$4:$M$5000,4,FALSE)=0,"***",VLOOKUP(D2 6,'Sales
Averages'!$A$4:$M$5000,4,FALSE))


"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!!