When creating a vlookup and you want it to return the closest match in the
lookup table rather than an exact match, I know that you don't enter FALSE
into the formula. However, when it cannot find an exact match, it
automatically returns the lower figure from the lookup table. For example, I
may have a figure of 10,750 in my main table and am asking it to search for
the closest match in the lookup table.
The lookup table contains various figures, including figures 10,000 and
11,000 but for £10,750 it returns £10,000 instead of the £11000.

How can you ask it to return THE closest match??

Hope this makes sense...

Thank you
Louise