Search for the cell content between sheets and copy corresponding
 

Hi Everyone,

I am working with this problem since some time, it will be a great if you
can help me to find out the solution. I have two sheets ("Sheet 1" and "sheet
2") with multiple columns and rows.
I have the task to search for the integer in cell "B2" of "sheet 1" in the
column "C" of "Sheet 2" and copy the corresponding "D column" value to "C2"
in Sheet 1. And this procedure should be executed untill the empty cell of
"Coloumn B" of "sheet 1" which might be after 100 or 200 rows.
e.g.: B2 of sheet 1 has a value of 2000. The macro has to find for 2000 in
column "C" of "sheet 2" and if it finds the value 2000 in C10 then the value
of D10 in sheet 2 has to be copied and pasted to the cell "C2" of "Sheet 1".

Thanks alot for your help....

Regards

Search for the cell content between sheets and copy corresponding
 

See VLOOKUP in Excel Help
--
Gary''s Student - gsnu200904


"Venkat" wrote:

Hi Everyone,

I am working with this problem since some time, it will be a great if you
can help me to find out the solution. I have two sheets ("Sheet 1" and "sheet
2") with multiple columns and rows.
I have the task to search for the integer in cell "B2" of "sheet 1" in the
column "C" of "Sheet 2" and copy the corresponding "D column" value to "C2"
in Sheet 1. And this procedure should be executed untill the empty cell of
"Coloumn B" of "sheet 1" which might be after 100 or 200 rows.
e.g.: B2 of sheet 1 has a value of 2000. The macro has to find for 2000 in
column "C" of "sheet 2" and if it finds the value 2000 in C10 then the value
of D10 in sheet 2 has to be copied and pasted to the cell "C2" of "Sheet 1".

Thanks alot for your help....

Regards

Search for the cell content between sheets and copy corresponding
 

In sheet1, cell C2:

=vlookup(B2,Sheet2!C:D,2,false)

then copy down to the bottom of sheet 1

Sam

"Venkat" wrote:

Hi Everyone,

I am working with this problem since some time, it will be a great if you
can help me to find out the solution. I have two sheets ("Sheet 1" and "sheet
2") with multiple columns and rows.
I have the task to search for the integer in cell "B2" of "sheet 1" in the
column "C" of "Sheet 2" and copy the corresponding "D column" value to "C2"
in Sheet 1. And this procedure should be executed untill the empty cell of
"Coloumn B" of "sheet 1" which might be after 100 or 200 rows.
e.g.: B2 of sheet 1 has a value of 2000. The macro has to find for 2000 in
column "C" of "sheet 2" and if it finds the value 2000 in C10 then the value
of D10 in sheet 2 has to be copied and pasted to the cell "C2" of "Sheet 1".

Thanks alot for your help....

Regards