So, does that mean if an exact match isn't found you want the closest match
that is less than the lookup value? Are you looking up numbers?

--
Biff
Microsoft Excel MVP


"Crimson King" wrote in message
...
How can I get results from an unsorted database in Excel similar to the
way
VLOOKUP works in a sorted database
--
Many Thanks,
CK