PDA

View Full Version : [SOLVED] Find values in a range then copy and paste data to different column



Seacowdaz
03-28-2018, 02:12 AM
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.

2193921939

p45cal
03-28-2018, 06:42 AM
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
03-28-2018, 11:08 AM
Thank you very much for your help really appreciate it, thats a lot simpler than i thought it would be :)