Forum Discussion
Excel Formula issue
Hello, So i am having an issue with a formula. =IF( A24 = STATS!B1:B32, STATS!AK1:AK32, "") produces an error everytime, Basically what I am trying to do is say if anything of column B is the...
It's always helpful if you upload a sample file with not working formula and desired output mocked up manually to visualize what exactly you are trying to achieve.
Btw, please try this and see if this is what you are trying to achieve.
=IFERROR(INDEX(STATS!$AK$1:$AK$32,MATCH(A24,STATS!$B$1:$B$32,0)),"")