Two-Way Lookups in Excel. If you are a Excel user then invariably you must've have used the lookup functions of Excel, namely HLookUp() and VLookup().
For those who haven't: A lookup function is used to return a value from a given table by looking up another value in the same table. A simple example could be a discount table consisting of two columns, Purchase Amount & Discount. You can write a formula that uses VLookUp() to determine the discount rate for a given purchase amount. Account Registration. Engineering ToolBox.