Excel 2010 Formula issue

[DGK1964]

I am trying to create a simple statement =OR(R2:R1300="179 2015",R2="RF Priority") -- =IF(R9="179 2015","YES","NO"). Each of these work perfectly fine if I am just typing in the text 179 2015 or RF Priority, these return the expected results of True or YES. However, the issue is that wheneve I have either of the formulas above that refers to a cell (that has a vlookup formula) the expected result is not correct. it always returns a NO. Any ideas?

 

[CharlesChuckieCharles]

assuming that you used the $ notation to fix the reference ( $A$1 ) and that the returned value is exactly the same ( no leading or trailing spaces ) it does seem odd... (also double check that the references you use are correct as in you expect D4 to equal "179 2015" but its actually D5)