Match cell contents from different sheets and if match, copy another cell's contents.

[Emo113]

Hello all,

I have a complicated request that I can't seem to solve.

I have two sheets with two columns in each sheet. I want to search the contents of Column A in Sheet1 against the contents of Column A in Sheet2 and if they match, I want to take the corresponding contents from the B column in Sheet2 and copy it to the corresponding B column of the matched A cell in Sheet1.

So far I found a way to match the contents and I get a Y or N if there is a match, but I can't find a way to copy the contents from Sheet2 to Sheet1 for the corresponding cell found.

My formula is

=IF(ISNA(MATCH(A2,Sheet2!$A2:$A31398,0)),"N","Y")

I have a header so that's why I'm starting at 2.

Thanks for any help!

 

[caabyyc]

	Sheet 1			Sheet 2
	A	B	C		A	B
1	id	CHK	Content(in sheet 2 if matched)	1	id	Content
2	A	Y	1	2	A	1
3	B	Y	2	3	B	2
4	C	Y	3	4	C	3
5	D	N	Not Found	5	C	4
6	E	Y	5	6	E	5
	Enter following in C1 of Sheet 1,then copy to bottom.
	IF(B2="Y",INDEX(Sheet2!B:B,MATCH(Sheet1!A2,Sheet2!A:A,)),"Not Found")

<colgroup><col style="width: 48pt;" width="64"> <col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1080;" width="30"> <col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1109;" width="31"> <col style="width: 140pt; mso-width-source: userset; mso-width-alt: 6656;" width="187"> <col style="width: 48pt;" span="3" width="64"> <tbody>
</tbody>

you have to confirm there is no duplicated items in column A of sheet 2,example, C in column A of sheet 2 was intentionally added as duplicated item, you will only see the content in B for the first matched "C".(form top to bottom)

Hello all,

I have a complicated request that I can't seem to solve.

I have two sheets with two columns in each sheet. I want to search the contents of Column A in Sheet1 against the contents of Column A in Sheet2 and if they match, I want to take the corresponding contents from the B column in Sheet2 and copy it to the corresponding B column of the matched A cell in Sheet1.

So far I found a way to match the contents and I get a Y or N if there is a match, but I can't find a way to copy the contents from Sheet2 to Sheet1 for the corresponding cell found.

My formula is

=IF(ISNA(MATCH(A2,Sheet2!$A2:$A31398,0)),"N","Y")

I have a header so that's why I'm starting at 2.

Thanks for any help!

 

[Emo113]

Thank you! It worked like a charm!