Help In Excel urgent Task Please

[mohamed_batal]

Please any expert here can help me to find the data of whole column A(3000 rows) in sheet 1 in another column A in sheet 2 rathar than search for each row and when the row is matched copy the whole column of sheet 2 in sheet 1 with in the same row for example copy the data column b & c from sheet 2 in column b& c in sheet 2

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]ahmed[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]mohamed[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]khaled[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]gamal[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

sheet (1)

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]c[/TD]
[/TR]
[TR]
[TD]gamal[/TD]
[TD]111[/TD]
[TD]usd[/TD]
[/TR]
[TR]
[TD]ali[/TD]
[TD]122[/TD]
[TD]egp[/TD]
[/TR]
[TR]
[TD]ahmed[/TD]
[TD]133[/TD]
[TD]uae[/TD]
[/TR]
[TR]
[TD]omar[/TD]
[TD]155[/TD]
[TD]usd[/TD]
[/TR]
[TR]
[TD]mohamed[/TD]
[TD]999[/TD]
[TD]egp[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[philwojo]

Try this on Sheet1, assuming your data is on sheet-2:

=IF(ISERROR(VLOOKUP($A1,Sheet2!$A$1:$C$5,2,0)),"",VLOOKUP($A1,Sheet2!$A$1:$C$5,2,0))

Place the code in B1 and copy down.


Now put this in C1 and copy down:

=IF(ISERROR(VLOOKUP($A1,Sheet2!$A$1:$C$5,3,0)),"",VLOOKUP($A1,Sheet2!$A$1:$C$5,3,0))

 

[mohamed_batal]

unfortunately it doesn't work
if you could help me i can send the excel file on your email to test with the code
my target is if the data in column a in sheet 1 match the data of column a in sheet 2 to copy the column b & C from sheet 2 to sheet a

 

[philwojo]

What results did you get and where did you put those formulas, which sheet and which cells?

And I apologize, if you data is longer that through cell C5 on sheet-2 you will need to update the formulas to reflect that.

I can't download sheets while I'm at work, but maybe others can help if you post that.

 

[macattackpro]

Hi,

Try INDEX:MATCH for this. Assuming your data is on sheet1 and you're wanting to input it to sheet2:

Cell B2 on sheet2:

=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0))

Cell C2 on sheet2:

=INDEX(Sheet1!C:C,MATCH(A2,Sheet1!A:A,0))

 

[hiker95]

unfortunately it doesn't work
if you could help me i can send the excel file on your email to test with the code
my target is if the data in column a in sheet 1 match the data of column a in sheet 2 to copy the column b & C from sheet 2 to sheet a

mohamed_batal,

Welcome to the MrExcel forum.

You may want to read the Forum Rules, Rule #4: at the next link:

https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[hiker95]

mohamed_batal,

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com