vlookup
Something else I forgot to mention. This is at the top of my sheet so if I
delete the 2 rows above the value I'm looking for I get an n/A.
"TomPl" wrote:
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.
|