Share via

I need a formula that matches cells in another sheet

Anonymous
2023-12-04T15:41:29+00:00

Hello!

I'm trying to find a formula or a way to actually match cells content in another sheet on the same workbook. I have a long list in Sheet1 with additional data and a small one on Sheet 2. I want to find the list on Sheet2 on Sheet 1. I can go one by one, but I'll never finish.

Ex. Sheet 1 has names and information in the next columns, Sheet2 only has some of the names that are on the long list.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-04T15:45:41+00:00

    You can use the VLOOKUP function to match cells in another sheet. Here's how you can do it:

    VLOOKUP function - Microsoft Support

    1. In Sheet2, select the cell where you want to display the matching data.
    2. Type the following formula: =VLOOKUP(A2,Sheet1!A:B,2,FALSE)
    3. Replace "A2" with the cell reference of the first name in Sheet2.
    4. Replace "Sheet1!A:B" with the range of cells in Sheet1 that contains the names and information. Make sure to include all columns that you want to display.
    5. Replace "2" with the column number of the information you want to display. For example, if the information is in the second column, use "2".
    6. Press Enter to display the matching data.

    The VLOOKUP function will search for the name in Sheet1 and return the corresponding information. If the name is not found, it will return an error. You can copy the formula to other cells in Sheet2 to match all the names.

    8 people found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-12-04T15:44:10+00:00

    Check out the VLOOKUP and XLOOKUP functions (the latter is available in Office 2021, Microsoft 365 and in Excel Online)

    0 comments