Thread: vlookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default vlookup

Unless the match is exact your formula will return the the first lookup that
is smaller.
=vlookup(h3,costs,2,false) will return only exact matches.

if you delete , 3" from the end of your lookup value it will give you the
correct answer.

You might consider reviewing the help file for vlookup.