Yes, Excel has an equivalent function to Access' NZ function. The function is called IFERROR.

The IFERROR function allows you to specify a value to return if a formula returns an error. This can be useful in situations where you want to display a specific value instead of an error message.

Here's an example of how you can use the IFERROR function to replace your current formula:

1. =IFERROR(VLOOKUP(A1,M1:N30,2,FALSE),0)

This formula will return the value from the VLOOKUP function if it is successful, and will return 0 if the VLOOKUP function returns an error.

You can also use the IFERROR function with other formulas that may return errors, such as division by zero errors or #VALUE! errors.