Beep when condition is met?

[Knockers]

Hi,

I have this formula

=IF(ISBLANK(A7),"",IFERROR(VLOOKUP(A7,'B - Return Stock Data'!A$2:B$500,2,FALSE), "Car Stock"))

It is working great but just wanted to up my game and see can I have the sheet Beep if it returns the value "Return" which will come in from the VLOOKUP?

I am aware it may require VBA but have no experience unfortunately with it.

Any help appreciated

 

[Muhammad_Usman]

You can solve it through visit here

 

[Knockers]

OK, so I use =IF(B2>3000,BeepMe(),"Return") is that right?

If so do I add this to my existing Formula or how did I use it?

 

[Muhammad_Usman]

you can use as easy to use it