Excel VLookup

Excel vlookup can be used to lookup a key and print its corresponding value. Very convenient when you quickly need to show desc from a set of values

Formula : =vlookup(col to lookup,array range to lookup, col num of the rest, TRUE = approximate match, FALSE = exact match)

Also to keep the range from changing when you copy over your formula to other cells,

When you enter the range in your formula, to keep the range from changing, you will need to enter the range as an Absolute Reference.  By that I mean, the range will be absolute, or will not change, when you extend the formula from the first cell to the rest.

To make the range Absolute, put a Dollar Sign ($)in front of both the column letter and the row number in the cell range.  For example, if the cell range is D1:F100 (Columns D, E, and F, from rows 1 through row 100), to make it an absolute range, so it will not change, enter the range in your formula as: $D$1:$F$100.  Now when you copy the formula down to subsequent rows, the range of D1:F100 will remain constant, or Absolute, in each of the formulas as they are copied down,and will not change as you copy the formula down.