Is this possible?

[exp]

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?

Please email me at
pyoo@energy.state.ca.us

 

[Jim North]

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

 

[Jim North]

But this is better:

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

 

[dk]

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.

 

[dk]

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