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...
Another alternative would be:
=IFNA(LOOKUP(2,1/(
STATS!B$1:B$32=A24),
STATS!AK$1:AK$32),
"")