VLOOKUP has two modes of matching, exact and approximate. If you need to lookup values to the left, see INDEX and MATCH, or XLOOKUP. VLOOKUP can only look to the right. The data you want to retrieve (result values) can appear in any column to the right of the lookup values: = VLOOKUP (H3 ,B4:E13, 2, FALSE ) // first name = VLOOKUP (H3 ,B4:E13, 3, FALSE ) // last name = VLOOKUP (H3 ,B4:E13, 4, FALSE ) // email address VLOOKUP only looks right