Hello,
I wonder if anyone can tell me why I am getting a 'FALSE' entry from the following formula: -
=IF($E$3=Sheet1!$A$1,Totals!E6,IF($E$3=Sheet1!$A$2,Totals!H6,IF($E$3=Sheet1!$A$3,Totals!K6,IF($E$3=Sheet1!$A$4,Totals!N6,IF($E$3=Sheet1!$A$5,Totals!Q6,IF($E$3=Sheet1!$A$6,Totals!T6))))))
What bothers me is that it has not given me problems before.
System Configuration: Windows / Chrome 88.0.4324.150