Excel If/Then with Cell Contents for True Result

I have several hundred phone numbers in column C.

I have several thousand phone numbers in columns AO & AP.

I want to determine if a cell reference (phone number) in column C occurs in columns AO or AP.

If true, then I want to report the contents of the cell in column AM (a name associated with the phone number) of the same row in which the phone number was found in column AO or AP.  I want this information reported into the cell in column E in the row of the phone number referenced in column C.

 

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 AO or AP.

 

=IF(COUNTIF($AO$4:$AP$17000,(INDIRECT(“c”&ROW())))=(INDIRECT(“c”&ROW())),(INDIRECT(“am”&ROW())),”N/A”)

 

Help.

 

 

Thank you.

By: Shawn

Leave a Reply

Your email address will not be published. Required fields are marked *