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.