Question: what is ref error in vlookup?
Answer: #REF! errors with VLOOKUP You may see a #REF! error with the VLOOKUP function, when a column is specified incorrectly. In the screen below, VLOOKUP returns #REF! because there is no column 3 in the table range, which is B3:C7: When the column index is set to the correct value of 2 the #REF!