Excel tools to demonstrate

Lookup and Reference Functions

I have heard an Excel expert make the claim that the VLOOKUP function, discussed earlier, is the most useful Excel function of all. Whether or not you believe this claim, the VLOOKUP and HLOOKUP functions are just two of some very useful reference functions in Excel’s arsenal. If you click on the f_x button for online help on Excel functions, you will see a Lookup and Reference category of functions that includes VLOOKUP, HLOOKUP, and several others. I will illustrate a few of these others here. Although they are arguably not as useful as VLOOKUP, they can definitely come in handy in certain situations.