Trouble with IFS statements

Hi,

newbie here - and am struggling with an IFS statement to work.

Basically, I am comparing data on 2 tabs, to see if the data is the same, so I can easily create a statement to check if both values in a cell are identical - I am using IF to say =IF(HD!C6=FMDI2!C6,TRUE,FALSE), so all straightforward (I guess I could also use "EXACT" to do the same, however, the tricky bit (for me anyway), if when both the cells are the same, but they both have "NO_MATCH" as the text in both cells, I want to return a different value (I hope that makes sense)!!


so to summarise, if both cells have RED in them, it returns "TRUE", if one has RED and one has BLUE, then it returns "FALSE" - but if both cells have NO_MATCH, I want it to return "NO VALUES".

Is this possible? Any help would be gratefully received!


Thanks

Something like

=IF(HD!C6=FMDI2!C6,IF(HD!C6="NO_MATCH","NO VALUES",TRUE),FALSE)

That's great thanks - works a treat

Thanks again!!