Solved Excel macro - copy/paste if there is match in text

December 10, 2011 at 07:58:52
Specs: Windows XP
Hello everybody,
I would be really happy if someone helps me with this macro. I have 4 columns: A, B, K, L.
A and B are full of data (thousands of rows) in K there are key words (about 10 but this number vary). I need macro, which will check word in K (for example K3) and then it will run through column A and if there is match (e.g. A200) then it will copy data from cell next to it (B200) and then it will paste it to L column (L3). Afterward it checks K4, K5....
This would save me literally hundreds hours of my time. Thanks a lot!

See More: Excel macro - copy/paste if there is match in text

Report •


#1
December 10, 2011 at 10:34:05
Have you tried a =VLOOKUP() function?

MIKE

http://www.skeptic.com/


Report •

#2
December 10, 2011 at 11:02:20
Well I haven't, but it looks like it should help me. I'll let you know how is it going. Thanks a lot mmcconaghy.

Report •

#3
December 10, 2011 at 13:11:45
✔ Best Answer
Try this in cell L1, drag down as needed:

=VLOOKUP(K1,$A$1:$B$1,2,FALSE)

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
December 12, 2011 at 14:02:45
Thank you, mmcconaghy, =VLOOKUP works for me well I have also been able to make some modifications. So everything works great!

Dubron


Report •


Ask Question