Why isn't this formula working?
I have the following formula (which works find) in cell H2
=VLOOKUP("RED",Scores!K:N,3,0)
I have the following formula in cell H3 which is not working. Any ideas why?
=IF(ISTEXT(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Sco res!$K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))), ROW()-1))),(INDEX(Scores!$M$1:$M$49997,SMALL(IF(Scores!$ K$1:$K$49997="RED",ROW(INDIRECT("1:50000"))),ROW()-1))),"")
Thanks
|