Lookup values on columns to the left in Microsoft Excel. The Excel Vlookup function cannot return values to the left. The Index and Match functions can be used instead for a more versatile lookup formula. Read more at http://www.infobarrel.com/Lookup_Data_in_a_Column_to_the_Left_in_Excel