Chapter 7 - Lookup Functions

An alternative to the VLOOKUP function is the horizontal or HLOOKUP function. This looks for a value in the top row of a table or array of values, and returns the value from the same column in the row you specify. Generally, the VLOOKUP function uses three arguments: the lookup-value, the table location and the column number. ................
................