Care to post your LOOKUP formula?

Dmitry Kopnichev wrote:
Hello
How to make LOOKUP give zero if it can't find the lookup_value?