Use Excel VLOOKUP to Match Names and Copy Values Between Sheets
Question details
Match names in two sheets and return the corresponding values from the first sheet to the second.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Names are in column A on both sheets, and the related values in Sheet1 column B are needed in Sheet2 column H.
- Observed behavior
- Each row in Sheet2 should show the value associated with its matching name on Sheet1.
Check that names are in column A on both sheets and that the values to return are in Sheet1 column B. Confirm that the sheet is named Sheet1 and that Sheet2 column H is available for the results.
Match Names with VLOOKUP and Return Values to Sheet2
Use an exact-match lookup to populate column H with values from Sheet1.
Open Sheet2 and select cell H2.
In H2, enter =IFERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE),"") and press Enter. The formula looks for the name in A2 on Sheet1 and returns its column B value.
Select H2 and drag the fill handle down column H for all rows with names.
Review column H against Sheet1. If a cell is blank unexpectedly, check the corresponding name for spelling differences or extra spaces.

Match Names Across Sheets in WPS Spreadsheets
Use the same VLOOKUP formula in WPS Spreadsheets to match names and return their associated values to another sheet.
- 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and check that Sheet1 contains names in column A and values in column B.
- 2. Select the destination: Open Sheet2 and select cell H2.
- 3. Enter the formula: Enter =IFERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE),"") in H2 and press Enter.
- 4. Apply it to other rows: Drag the fill handle from H2 down column H, then check the returned values.

Frequently Asked Questions
What does FALSE do in the VLOOKUP formula?
FALSE requires an exact match for the name in Sheet2 column A. If no match is found, IFERROR makes the result appear blank.
What if the source sheet has a different name?
Replace Sheet1 in the formula with the source sheet's name. For a name containing spaces, use single quotes, as in =IFERROR(VLOOKUP(A2,'Source Data'!A:B,2,FALSE),"").
Why is a result blank when the name appears on both sheets?
Check the names for spelling differences or extra spaces. IFERROR also hides other formula errors, so temporarily use =VLOOKUP(A2,Sheet1!A:B,2,FALSE) in H2 to inspect the error.
What happens if a name appears more than once on Sheet1?
VLOOKUP returns the column B value from the first matching row. Check Sheet1 column A for duplicates if you need a different match.




