Should actually be:
=if(isnumber(match(B1,A:A,0)),A1,"")
--
Regards,
Tom Ogilvy
"Tom Ogilvy" wrote in message
...
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