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...
The reason for the error is IF does not treat B1:B32 as an array. Excel isn't checking all those cells to see if A24 is present. As the others have advised, you'll need a lookup function.
If you're running a fully updated version of O365 you may get a spilled result with your original formula. Excel is getting smarter!
If you're running a fully updated version of O365 you may get a spilled result with your original formula. Excel is getting smarter!