When using the VLookup Command to return a value based on a column of data, the default answer (when an exact answer is not available) will be the answer with the closest yet smaller value based on the data given. I want to run the VLookup command and have the value returned be the closest yet greater value. I’m lost on this one.
