Is there a way that I can lookup the closest value of a given number in a
table of data using Index/Match?

I am looking for a formula that will provide the same functionality as
setting the VLOOKUP Range value to true but allows me to have more flexibilty
as to the data I can work with. Any help with this would be greatly
appreciated.

Chad