Insert the value of a different column depending on matching cell value

[suzeet]

Hello Everyone
Hope you are doing good. I want to put the value of SEQ NO in the SEQNO_I column when bot the ID column values matches. As per example below, when ID 4280 matched, SEQ NO 559 inserted in the SEQNO_I column

SEQ NO	ID	SEQNO_I	ID	ADDRESS
559	4280	559	4280	1155 PRESSLER ST
634	5678	559	4280	1515 HOLCOMBE BLVD
549	6901	559	4280	1515 HOLCOMBE BLVD UNIT 1354
358	16483	559	4280	1515 HOLCOMBE BLVD UNIT 1534
496	19814	549	6901	100 NAVARRE PL
		549	6901	1915 LAKE AVE
		358	16483	1812 FITZWATER ST
		496	19814	1045 SOUTHCREST DR STE 200
		496	19814	1250 HIGHWAY 54 W STE 102

<tbody>
</tbody>

 

[Peter_SSs]

Welcome to the MrExcel board!

1. Can you confirm that you have shown the sheet with the results you want and that the SEQNO_I column was originally blank?

2. Are you looking for a formula solution or a macro?

 

[Peter_SSs]

Here's a formula suggestion. Is this what you meant?
Formula in C2 is copied down.

Excel Workbook
	A	B	C	D
1	SEQ NO	ID	SEQNO_I	ID
2	559	4280	559	4280
3	634	5678	559	4280
4	549	6901	559	4280
5	358	16483	559	4280
6	496	19814	549	6901
7			549	6901
8			358	16483
9			496	19814
10			496	19814
Sheet1

 

[suzeet]

Here's a formula suggestion. Is this what you meant?
Formula in C2 is copied down.

Sheet1

	A	B	C	D

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:70px;"><col style="width:54px;"><col style="width:76px;"><col style="width:54px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: right"]SEQ NO[/TD]
[TD="align: right"]ID[/TD]
[TD="align: right"]SEQNO_I[/TD]
[TD="align: right"]ID[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]634[/TD]
[TD="align: right"]5678[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]6901[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="align: right"]358[/TD]
[TD="align: right"]16483[/TD]
[TD="align: right"]559[/TD]
[TD="align: right"]4280[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]
[TD="align: right"]496[/TD]
[TD="align: right"]19814[/TD]
[TD="align: right"]549[/TD]
[TD="align: right"]6901[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]

[TD="align: right"]549[/TD]
[TD="align: right"]6901[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]

[TD="align: right"]358[/TD]
[TD="align: right"]16483[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]

[TD="align: right"]496[/TD]
[TD="align: right"]19814[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]

[TD="align: right"]496[/TD]
[TD="align: right"]19814[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula C2 =INDEX(A$2:A$6,MATCH(D2,B$2:B$6,0)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Yes, this was what I am looking for. Thank you very much

 

[Peter_SSs]

Yes, this was what I am looking for. Thank you very much

Great. Thanks for letting us know. You're welcome.