if you only need to know if there is a match try
=vlookup(E406,M3:M403,1,false)
you will get an error message if there is no match

"nicoleeee" wrote:


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