I have situation where I have to find the name in column B from colum
J. Column B has about 2000 users name and in column J only have abou
450. I want to search first name from column J in Column B, if th
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 don’t know anything about VB).

Thanks.

Yas

--
myguess2
-----------------------------------------------------------------------
myguess21's Profile: http://www.excelforum.com/member.php...fo&userid=2957
View this thread: http://www.excelforum.com/showthread.php?threadid=49338

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

In cell M1 put

=IF(ISERROR(MATCH(J1,B:B,0)),"","Keep")

and drag down as many as necessary

"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

Cool. it works for what i need to do.

Thanks a lot.

Yash.

Philip Wrote:
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




--
myguess21
------------------------------------------------------------------------
myguess21's Profile: http://www.excelforum.com/member.php...o&userid=29578
View this thread: http://www.excelforum.com/showthread...hreadid=493387