Left Lookup. The VLOOKUP function only looks to the right. To look up a value in any column and return the corresponding value to the left, simply use the INDEX and the MATCH function. ... The MATCH function returns the position of a value in a given range.