westend9876
Member
Hi. Can someone tell me why this formula will not work?
=IF(INDEX($AC$8:$AC$250,MATCH(Y8,$AY$8:$AY$250,0)=INDEX($AL$8:$AL$250,MATCH(Y8,$AY$8:$AY$250,0),"YES","NO")))
Excel says the formula typed contains error.
=IF(INDEX($AC$8:$AC$250,MATCH(Y8,$AY$8:$AY$250,0)=INDEX($AL$8:$AL$250,MATCH(Y8,$AY$8:$AY$250,0),"YES","NO")))
Excel says the formula typed contains error.