Hi,
No need for VBA to do that, use a worksheet formula in column M
Like this:
=IF(ISERROR(VLOOKUP(J:J,B:B,1,FALSE)),"","KEEP")
In the middle, use VLOOKUP, search for whats in column J in Column B,
if that returns no error, then output 'KEEP' (IF ... THEN ... ELSE )
else output nothing
HTH
Philip
"myguess21" wrote:
I have situation where I have to find the name in column B from column
J. Column B has about 2000 users name and in column J only have about
450. I want to search first name from column J in Column B, if the
user name found, write a word €śkeep€ť in column M. if not then skip.
Is it possible to do this? If yes, can someone guide me how to do it.
(I dont know anything about VB).
Thanks.
Yash
--
myguess21
------------------------------------------------------------------------
myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578
View this thread: http://www.excelforum.com/showthread...hreadid=493387