How to handle numbers as the lookup value in Excel Vlookup and use absolute cell references HD

An explanation and demonstration of how Excel requires the lookup value to be text, and not a number. This is useful where you want to lookup, for example, an ID which has been initially entered as a number. Also how to use absolute cell references (dollar signs) in the formula for multiple lookups