Need help with referencing.

[ktmiln2]

So, here's my deal. I have two separate sheets, one with parcel ID #'s and corresponding names. In the second sheet, I have only a select group of parcel ID #'s, all of which exist in the first sheet (>10%). What I was wondering is how to get my second sheet, with the smaller list of ID's, to go to the first sheet and copy over the corresponding names that go with each Parcel ID. I would do this the old fashion way, but I'm dealing with a couple thousand ID's and am sure there is an easier way.

 

[stnkynts]

On both sheets which column is the Parcel ID and "corresponding name" in? Is it for example. Sheet 1 Column A = Parcel ID, Sheet 2 Column B = Corresponding Name? Same for Sheet 2.

 

[hiker95]

ktmiln2,

Welcome to the MrExcel forum.


Depending on the structure of both worksheets, you may be able to use VLOOKUP, or Index Match.


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net

 

[ktmiln2]

In Sheet 1, Column A is Parcel ID Column B is Name. In sheet 2, Column A is Parcel ID.

 

[ktmiln2]

ktmiln2,

Welcome to the MrExcel forum.


Depending on the structure of both worksheets, you may be able to use VLOOKUP, or Index Match.


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net

I am using Excel 2007. I will try to put a mock together, as the actual file has sensitive information I probably shouldn't share.

 

[hiker95]

ktmiln2,


Sample raw data in worksheet Sheet1:

Excel Workbook
	A	B
1	Parcel ID	Name
2	B2222	ktmiln2
3	A1111	hiker95
4
Sheet1

And, in worksheet Sheet2:

Excel Workbook
	A	B
1	Parcel ID	Name
2	A1111	hiker95
3	B2222	ktmiln2
4
Sheet2

The formula in cell B2, copied down:


=VLOOKUP(A2,Sheet1!$A$1:$B$10,2,FALSE)


You will have to extend the $B$10 to a number larger than the last used row in worksheet Sheet1.

 

[ktmiln2]

ktmiln2,


Sample raw data in worksheet Sheet1:

Excel Workbook
	A	B
1	Parcel ID	Name
2	B2222	ktmiln2
3	A1111	hiker95
4
Sheet1

And, in worksheet Sheet2:

Excel Workbook
	A	B
1	Parcel ID	Name
2	A1111	hiker95
3	B2222	ktmiln2
4
Sheet2

The formula in cell B2, copied down:


=VLOOKUP(A2,Sheet1!$A$1:$B$10,2,FALSE)


You will have to extend the $B$10 to a number larger than the last used row in worksheet Sheet1.

Perfect! Thank you very much!

 

[hiker95]

ktmiln2,


Or:

Excel Workbook
	A	B
1	Parcel ID	Name
2	A1111	hiker95
3	B2222	ktmiln2
4
Sheet2

The formula in cell B2, copied down:

=INDEX(Sheet1!$B:$B,MATCH($A2,Sheet1!$A:$A,0))