excel training course - Lookup tables

Vlookup looks up a value in the first COLUMN of information vertically.

Hlookup looks up a value in the first ROW of information horisontally

Lookup returns a value either from a one-row or one-column range or from an array. The LOOKUP function has two syntax forms: vector and array. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range. The array form of LOOKUP looks in the first row or column of an array for the specified value and returns a value from the same position in the last row or column of the array.