Find values in a range then copy and paste data to different column

[Seacowdaz]

Hello All.

Firstly I apologise if this has been covered somewhere before, I have searched the internet but due to my rather limited knowledge of Excel VBA have been unable to find something or even modify existing code to meet my requirements.

What I would like is a way of searching a column of data, in this case Column C for a name and then to copy that Cell into the same Cell in Column E.

So searching for John Wayne would copy the contents of Cells C2 and C3 into cells E2 and E3.

The other thing is I would like to search through a range of names rather than one specific one, the list of names in this example would be listed in column J and the amount of names to search would change on a daily basis.

Sample Data.xlsxSample Data.xlsx

[p45cal]

in E2:
=IF(ISNUMBER(MATCH(C2,$J$2:$J$9,0)),C2,"")
copy down.
Altering the list in j2:j9 will/could result in column E results changing.

[Seacowdaz]

Thank you very much for your help really appreciate it, thats a lot simpler than i thought it would be