I have a VLOOKUP formula that when a recognised entry is made. A cell is populated with the answer. My problem is that some entries are made that are not in the table so the answer is, what ever the closest match is. Can the formula include something that gives the answer “not on list” when a non-table entry is made.