Hi,

I Want to have two tables calculating different values based on a type of vendor, which then feed into a sort of a "heat map". I am using the following formula
=IFERROR(IF($B7="TextHere",

(INDEX($B$153:$AW$173,MATCH(G$6,$B$153:$B$173,0),MATCH($D7,$B$153:$AW$153,0))*INDEX($B$270:$V$351,MATCH($C7,$B$270:$B$351,0),MATCH(G$6,$B$270:$V$270,0))*HrsPerYear*$F$3*(1-$F$4)),
(INDEX(hsc!$B$3:$AW$23,MATCH(G$6,hsc!$B$3:$B$23,0),MATCH($D7,hsc!$B$3:$AW$23,0))*INDEX($B$270:$V$351,MATCH($C7,$B$270:$B$351,0),MATCH(G$6,$B$270:$V$270,0))*HrsPerYear*$F$3*(1-$F$4))),0)
Currently, both tables referenced ($B$153:$AW$173 and hsc!$B$3:$AW$23) are EXACTLY the same.

However, the formula fails for "value_if_false" section of the "if" statement. Is there anything I am doing here wrong?

The column part of the second index-match (MATCH($D7,hsc!$B$3:$AW$23,0)) is the one failing


Please help!!

Thanks