Compare Worksheets and Return data

[vbjohn]

I have to Sheets that I would need to compare and return data.

If data from Sheet2 (Column A) Matches Sheet1(Column C) (row) then return all data in Sheet2

Sheet2 has about 8900 Records

I tried this and it does not work.
=INDEX(Sheet1!A5:U5,MATCH(A1,Sheet1!C5:C9150),1)

Hope this makes sense.

[Domski]

Maybe:

=INDEX(Sheet1!$A$5:$U$9150,MATCH($A1,Sheet1!$C$5:$C$9150,0),COLUMN(A1))

Copied down and across.

Dom

[vbjohn]

What I mean is:
Sheet 1 Data:
A1 = 1234
B1 = HI
C1 = This is a test
D1 = YES

A2 = 2345
B2 = Hello
C2 = Not a test
D2 = NO

A3 = 3456
B3 = C'ya
C3 = Again a test
D3 = Maybe

etc...

Sheet 2
A1 = 2345

a new sheet or sheet 2... should read

A2 = 2345
B2 = Hello
C2 = Not a test
D2 = NO

Maybe I need to do VBA on it... Not sure.

[Domski]

Can you upload a sample workbook?

Dom

[vbjohn]

Can you upload a sample workbook?

Dom

Here it is... Basically

If ID's Match from Sheet2 to Sheet1.. then in a new worksheet put in all data (A5:U5) ex: that is from Sheet1.

Here is some test data...