Lookup Values on Columns to the Left in Microsoft Excel
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