Thread: VLookUp
View Single Post
  #5   Report Post  
James
 
Posts: n/a
Default

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