I have an excel document that I am looking up weights in a table. When I run
the macro I am always pulling the value that is less than the value that I
need. For example I have 903 as a weight and in the table I have 815 which
is 17.1 and 919 which is 18.3. I want to pull the 18.3, but I keep pulling
the 17.1. Is there a way to do this with the vlookup or is there another
formula that will grab the larger value?