Hi, I need to compare text values in one cell to text values in another
range of cells. Basically I need a formula that tells me if the text
in cell E406 equals the text in any of the cells between M3 and M403.
I tried =E406=M3:M403, but that didn't work. If anyone knows how to do
this please let me know!


--
nicoleeee
------------------------------------------------------------------------
nicoleeee's Profile: http://www.excelforum.com/member.php...o&userid=23442
View this thread: http://www.excelforum.com/showthread...hreadid=389445