Function Problems

Use Excel VLOOKUP to Match Names and Copy Values Between Sheets

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 869 views

Question details

Match names in two sheets and return the corresponding values from the first sheet to the second.

Use Excel VLOOKUP to Match Names and Copy Values Between Sheets
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.
Before you start

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.

Solution 1Recommended

Match Names with VLOOKUP and Return Values to Sheet2

Use an exact-match lookup to populate column H with values from Sheet1.

1
Select the first result cell

Open Sheet2 and select cell H2.

2
Enter the lookup formula

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.

3
Fill the formula down

Select H2 and drag the fill handle down column H for all rows with names.

4
Check the results

Review column H against Sheet1. If a cell is blank unexpectedly, check the corresponding name for spelling differences or extra spaces.

Match Names with VLOOKUP and Return Values to Sheet2
Duplicate names and errors: VLOOKUP returns the first matching name in Sheet1. IFERROR displays a blank for any formula error, including a name that is not found.
Match data in WPS Spreadsheets

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. 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. 2. Select the destination: Open Sheet2 and select cell H2.
  3. 3. Enter the formula: Enter =IFERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE),"") in H2 and press Enter.
  4. 4. Apply it to other rows: Drag the fill handle from H2 down column H, then check the returned values.
Match names and retrieve values with VLOOKUP.Open and edit Microsoft Excel XLSX and XLS files.Fill formulas down a column for multiple rows.Work in a familiar spreadsheet interface.
microsoft office alternative - wps office

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.