IF(AND( statement error in Validation List?

[rguliuzza]

Hello Group,

I am perplexed by this issue and cannot identify the cause. I have written some logic regarding the content of two cells, (D61 and D62). The following logic works without error:

=IF(AND(D$61="Jacket",AA62=2),Cooling_PE, IF(D$61="Electric_Blanket",Common!$A$13,Common!$A$13))

Where "Common" is a TAB where I keep all the Formula Name groups.

I then insert a second IF(AND( statement in the middle and get the error: "A named range you specified cannot be found"

=IF(AND(D$61="Jacket",AA62=2),Cooling_PE, IF(AND(D$61=”Jacket”,AA62<>2),Cooling_Source,IF(D$61="Electric_Blanket",Common!$A$13,Common!$A$13)))

All my Formula Names are identified - (Cooling_PE and Cooling_Source)

Is there something I am missing in creating this logical statement?

Thank you in advance for your replies.

With best regards,
Rick

 

[JoeMo]

Did you use the Name Manager to see if Cooling_Source has a Refers to: error?

 

[rguliuzza]

Hi Joe,

Yes I did. What was interesting, if I type the formula in it seems to work; however, if I copy and paste it in, it fails. I have checked for leading and trailing spaces and found none. I am not sure why this occurs.

I must have Excel Gnomes.

Thank you.

With best regards,
Rick

 

[JoeMo]

Makes me think your source for obtaining the copy is suspect - maybe has some non-printing characters or ...?