Compare and copy/paste
 

Hi
I have two sheets with about 500 rows
"Sheet1":
A1
3000
B1
3001
C1
3002
and furter on to about 500
"Sheet2":
A1
3002
B1
3000
C1
3001
and furter on to about 500

The function I need has to be put in cell D1 in "sheet1" and need to check
of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1",
if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1"

The cells in column A "sheet1" one has not the same rows as in "sheet2",, if
they had the same row it would be easy :)
Eks :
A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7


Do anyone understand what I am looking for???? PLS help :)



--
Just a regular user

Compare and copy/paste
 

sorry got posted 2 times, got a errormessage the first time, and tried again,
sorry
--
Just a regular user


Rockbear skrev:

Hi
I have two sheets with about 500 rows
"Sheet1":
A1
3000
B1
3001
C1
3002
and furter on to about 500
"Sheet2":
A1
3002
B1
3000
C1
3001
and furter on to about 500

The function I need has to be put in cell D1 in "sheet1" and need to check
of any of the cells in column A in "sheet 2" has the value of A1 in "sheet1",
if it does I need to put the value of F1 in "sheet2" into D1 in "sheet1"

The cells in column A "sheet1" one has not the same rows as in "sheet2",, if
they had the same row it would be easy :)
Eks :
A1 in "sheet1" have the value 3000, but in "sheet2" the value 3000 is in A7


Do anyone understand what I am looking for???? PLS help :)



--
Just a regular user