Reference functions

=VLOOKUP(lookup_value, range, col/row index,true/false)

Vlookup/hlookup – vertical lookup if the 1^st argument value you are trying to find is down a column; horizontal lookup if the 1^st argument value you are trying to find is across a row.

Lookup_value – is the value you are trying to “find” and it ALWAYS has to be found in the first column of the range (i.e. 2^nd argument)

Range – includes both the lookup value in its first column and the return value of the function in another column; thus, the result of the function is found to the right of the lookup_value.

Col/Row Index – this is an integer number that specifies which column (or row) IN THE RANGE (specified as argument 2) the result of the function can be found.

True/False –

False è you want to find an EXACT MATCH for the lookup_value in the first column (or row) of the range.

True (default value) à “the greatest value that does not exceed the criteria”

(1) the first column (or row) of the range must be in ascending order

(2) each value in the first column represents a range of values

CONVERT TO -----à months quarters year