I am trying to use the following formula to return a cell value from the first array in the 3rd column if, the cells in B5:D5 match C4 and if C5:E5 match E4.
=SUM(IF($B$5:$D$5=C4,IF($C$5:$E$5=E4,3,0),0))
However it only seems to return the number that I enter in as the column number (ie 3)! Am I using the incorrect function?
Regards
Leann
=SUM(IF($B$5:$D$5=C4,IF($C$5:$E$5=E4,3,0),0))
However it only seems to return the number that I enter in as the column number (ie 3)! Am I using the incorrect function?
Regards
Leann