P.S. thanks for the #N/A correction

"Tom Ogilvy" wrote:

Not if you look at the OP's example. It is as I wrote it and I posted a
correction to account for the N/A.

--
Regards,
Tom Ogilvy



"Charlie" wrote in message
...
Is this is what you meant? (Search col A for each element in col B?)

=
IF(MATCH(B1,A:A,0),B1,"")
red blue blue
green white white
blue yellow #N/A
black black black
white blue blue

but in both cases how do you get rid of "#N/A" when there is no match?

"Tom Ogilvy" wrote:

in C1
=if(match(B1,A:A,0),A1,"")

then drag fill down the column.

--
Regards,
Tom Ogilvy

"myguess21"
wrote in
message ...

Thanks for quick response.

No this is string. Just want to search the value from column 2 in
column1 if found out put in column 3.


--
myguess21

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