reference cell

[thepartydj]

I am looking for a formula.
Sheet 1 I have a number in A:1, so in A:2 I need a formula that looks at the number in Sheet 1 A:1, then finds that number on Sheet 2 Column A, When it finds the matching number it displays the new number located in Sheet 2 Column B next to the matching number.

 

[kweaver]

Are the values on Sheet2 in column A unique?

=VLOOKUP(A1,Sheet2!$A$1:$B$10,2,FALSE)

Change the range for Sheet2 accordingly as I only used 10 rows in Sheet2.

 

[thepartydj]

Yes they are unique numbers in column A on Sheet 2. Can you help out more, I can't seem to get it to work.

So I have the number 22170255 in Sheet 1 Column A Row 7
The same number is also on Sheet 2 Column A somewhere
I need to find the number on Sheet 2 in Column A and then display the number right next to it on Sheet 2 Column B

 

[kweaver]

In Sheet1, in the B1 cell, enter this formula after adjusting however many rows you have on Sheet2.

=VLOOKUP(A1,Sheet2!$A$1:$B$11,2,FALSE)

Then, fill that formula down in Sheet1's B column to however many rows you have in Sheet1.

Here's my Sheet1

[TABLE="width: 128"]
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64, align: right"]4[/TD]
[TD="class: xl63, width: 64, align: right"]800[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]22170255[/TD]
[TD="class: xl63, align: right"]1000[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]1300[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]15000[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63, align: right"]1100[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]1300[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]8[/TD]
[TD="class: xl63, align: right"]1200[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]1400[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63, align: right"]1100[/TD]
[/TR]
</tbody>[/TABLE]

And, here's my Sheet2

[TABLE="width: 128"]
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64, align: right"]1[/TD]
[TD="class: xl65, width: 64, align: right"]500[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl65, align: right"]600[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl65, align: right"]700[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]4[/TD]
[TD="class: xl65, align: right"]800[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]5[/TD]
[TD="class: xl65, align: right"]900[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22170255[/TD]
[TD="class: xl65, align: right"]1000[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]7[/TD]
[TD="class: xl65, align: right"]1100[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]8[/TD]
[TD="class: xl65, align: right"]1200[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]9[/TD]
[TD="class: xl65, align: right"]1300[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]6[/TD]
[TD="class: xl65, align: right"]1400[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]10[/TD]
[TD="class: xl65, align: right"]15000[/TD]
[/TR]
</tbody>[/TABLE]