How to display Hit if the item exists and Miss if it does not exist using the VLOOKUP function.(Microsoft Excel)

Includes formulas and examples of use.