title: Excel If/Then with Cell Contents for True Result
body: <p>I have several hundred phone numbers in column C.
  I have several thousand phone numbers in columns AO &amp; AP.
  I want to determine if a cell reference (phone number) in column C occurs in columns AP or AO.
  If true, then I want to report the contents of the cell in column AM (name associated with the phone number) of the same row in which the phone number was found in column Y or Z.  I want this information reported into the cell in column E in the row of the phone number referenced in column C.</p>
  
  <p>This is what I have so far and it almost works but I get no true reports back even though I can see the phone numbers in Columns C and AP or AP.</p>
  
  <p>=IF(COUNTIF($AO$4:$AP$17000,(INDIRECT("c"&amp;ROW())))=(INDIRECT("c"&amp;ROW())),(INDIRECT("am"&amp;ROW())),"N/A")</p>
  
  <p>Help.</p>
  
  <p>Thank you.</p>