web dev
Reputation: 330
copy Column B of sheet2 by matching values of Column A from sheet2 to Column A sheet1
I have a complex scenario, I want to copy Column B of sheet2 to Column C of sheet1 by match cells of column A of sheet2 against Column A sheet1, please have a look at below tables.
Sheet 1
Sheet 2
Resultant Sheet 1 After formula
Upvotes: 1
Views: 319
Answers (1)
Harun24hr
Reputation: 36880
Its no so complex. Try Index/Match like-
=IFERROR(INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0)),"")
VLookup() will also work in this way-
=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,FALSE),"")
With Excel365, single XLOOKUP() will give you desired result.
=XLOOKUP(A2,Sheet2!A:A,Sheet2!B:B,"")
Upvotes: 1
Related Questions
- How to insert matching values from one sheet into another in Excel
- When values in cells in two columns match values in the same columns in another sheet, then copy the whole row
- How to compare two columns in Excel (from different sheets) and copy values from a corresponding column if the first two columns match?
- How to match the cell values and copy them from different sheets
- Finding matching value in sheet 2 and copy adjacent cells value in sheet 1
- How to compare two columns in Excel and if match, then copy the cell next to it
- Match name and copy row from sheet 1 to sheet 2 on corresponding column
- Copy value from one sheet to another
- Need to copy a column from on Sheet to another based on a value
- Copy Data from One Sheet to Another Sheet by Matching Column Names