The VLOOKUP() works by taking up four arguments. First one is the value to be looked up, The second one is the lookup range or lookup table. The third argument specifies the column offset. Remember that valookup numbers column from 1, and the first column is always the left most collumn, The fourth argument is if your are looking for exact match or not. So ti could be 1 or 0 or TRUE or FALSE.