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

A	B	C
ahmed
mohamed
khaled
gamal

<tbody>
</tbody>

sheet (1)

A	B	c
gamal	111	usd
ali	122	egp
ahmed	133	uae
omar	155	usd
mohamed	999	egp

<tbody>
</tbody>

 

[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