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
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