How to Use VLOOKUP in Excel: 4 Easy Steps (For Beginners) VLOOKUP looks for the lookup value in the leftmost column of the lookup table or table array, aiming to find the matching value That means whatever you want to return must be located somewhere to the right of the column you’re searching in