Dec 04 2018 02:46 PM - edited Dec 04 2018 02:47 PM
Hello,
I have two columns of data, if the two match I would like the result in the third column to be "QC OK', if they don't I would like the result to be "QC Fail", if the second column is left blank I would like the result in the third column to be left blank. The IF function only allows two results. What function would I use so I can get the third?
Thank you.
Dec 04 2018 03:11 PM
NenaK, choose CHOOSE(). :)
=CHOOSE(COUNTIFS(A1:B1,B1)+1,"","QC Fail","QC OK")