VLOOKUP can have a zero or a one at the end - if you have a one it will look
for the closest match so may return values even if there are no matches. If
you use a zero it will only return a value if there is an exact match. eg.
VLOOKUP(A1,D1:E6,1,0)
J
|