• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index Match Formula won't work

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")

Check closing parenthesis for Index Functions..
 
Back
Top