If False then (another formula)

[Kirstym1918]

Hi all,

How do I add to this formula =IF(COUNTIF(Monday!$G$6:$I$25,$B2)>0,"W","")

It looks in the Monday range for a match with B2 then returns "W" but if false I would like it to carry out another formula to find a match but return R as per below, any idea how I can do this.
=IF(COUNTIF(Monday!$T$6:$U$31,$B2)>0,"R","")

Many Thanks

 

[JerryH09]

Does this work?
=IF(COUNTIF(Monday!$G$6:$I$25,$B2)>0,"W",IF(COUNTIF(Monday!$T$6:$U$31,$B2)>0,"R",""))

 

[Kirstym1918]

Hi Jerry,

Thanks for the reply, No it doesn't work, I tried that previously, it stops working on both formulas unfortunately.

 

[JerryH09]

Try this
=IF(COUNTIF(Monday!$G$6:$I$25,$B2)>0,"W",IF(COUNTIF(Monday!$g$6:$i$25,$B2)>0,"R",""))

 

[Kirstym1918]

It the same formula, different ranges

 

[JerryH09]

Can you post a copy of your data here?

 

[gaz_chops]

The formula in post #2 looks like it should work! What result do you get?

 

[Kirstym1918]

Hi,

I'm struggling to upload anything. The file contains a lot of confidential information so I cant really attach the full file

 

[gaz_chops]

Do the 2 formulas work ok independently of each other?

 

[Kirstym1918]

The formula in post #2 looks like it should work! What result do you get?

It doesn't give anything Gaz, Just a blank cell.