=IF(D1<1,INDEX('Story Event Lookup'!$D$2:$D$300,MATCH('Story Events'!$E$2,'Story Event Lookup'!$B$2:$B$300,0)),INDEX('Story Event Lookup'!$D$2:$D$300,MATCH('Story Events'!$D$1,'Story Event Lookup'!$A$2:$A$300,0)))
no matter what value is in D1 it does the index from E2. I checked a simple if(d1<1,"true","false") and it returns true and false correctly but when I use the index codes it always does the true.
Both index codes work when not in the if statement by themselves.
Bookmarks