Comparing text and returning boolean values

Tech-Archive recommends: Fix windows errors by optimizing your registry


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?action=getinfo&userid=23442
View this thread: http://www.excelforum.com/showthread.php?threadid=389445

.

Relevant Pages

  • Re: Referencing a cell for a row
    ... I placed this formula in my cell ... tonydepo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15306 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Help with difference in time macro
    ... First of all I want to say this is my first time here and I am on my ... Compare H with system date and insert the difference in "I" ... the background of the cell should be colored in RED. ... This is based on a 24/5 clock (meaning it does not include Saturday and ...
    (microsoft.public.excel.programming)
  • RE: Compare 2 sets of data
    ... If you want to compare column A with F, you have to be positioned in Column ... F, go to conditional formating, enter where the cell vallue is not equal to ... range is different from the second set or Disability Code is different and so ...
    (microsoft.public.excel.worksheet.functions)
  • RE: comparing componants of tables
    ... jimbo, I have to make several assumptions to provide this solution. ... Second assumption, when you do comparisons, you're wanting to compare one ... weights, and not weight for one person to belt size for someone else. ... Here is the basic formula that I placed into cell B18 of this comparison ...
    (microsoft.public.excel.newusers)
  • Re: Autopopulating a cell
    ... an entry into the a1 cell. ... Tralee6 ... Tralee6's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29273 ... Prev by Date: ...
    (microsoft.public.excel)