# Is this possible?

#### exp

##### New Member
I have two columns of hard numbers in Sheet 1 (columns A and B).

In sheet 2, i have one column of numbers (column A) and a blank column (column B)

In Column B of sheet 2, is it possible to put in a formula that would look at the number in Column A...then search for that same number in Column A of Sheet 1...and report back with the corresponding number in Column B (of sheet 1) and copy it down to Column B of sheet 2?

pyoo@energy.state.ca.us

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
hello exp,

... and welcome to the board!

This will do it:

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

_________________
JRN

Excel 2000; Windows 2000
This message was edited by Jim North on 2002-09-18 11:51

But this is better:

=IF(ISNA(VLOOKUP(A1,Sheet1!\$A\$1:\$B\$10,2,0)),"",VLOOKUP(A1,Sheet1!\$A\$1:\$B\$10,2,0))

Sounds like you need the VLOOKUP function.

For example this searches range A1:B10 of sheet1 for a value found in A1 of sheet2 and returns the corresponding value from sheet 1.

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

There are loads of examples of VLOOKUP on this site. Just click Search and enter VLOOKUP as a keyword.

Sorry Jim, I'm a bit slow on the keyboard today

Replies
1
Views
127
Replies
7
Views
215
Replies
18
Views
408
Replies
7
Views
291
Replies
4
Views
252

1,219,961
Messages
6,151,169
Members
451,011
Latest member
OH650R

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back