Vlookup not selecting first cell from top.

Hi,   I have a table with more than one match for the Lookup_value.  If there are four matches, then the result returned is from the last match found and not the first.  I've solved this be sorting...