hi here is the scenario

i will copy data from column A and Column C. If the data in column A and C is the same, then it will copy the value of Column B,D,E which is in the same row as Column A to a new worksheet. Also i nd it to be able to run thru the whole column of C to check every value. I dun tink vlookup is able to fulfil my requirements. Anyone has any solutions?

A B C D E
1 AB 9 1A 2A
2 BC 10 1B 2B
3 CD 5 1C 2C
4 DE 3 1D 2D
5 EF 2 1E 2E
6 FG 8 1F 2F
7 GH 9 1G 2G

Col E is newly added.
eg: row 3 in col A = 3, row 4 in Col C = 3, how do i copy row 3 in col B,D,E into a new worksheet? i will nd it to run thru the whole col C