=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 same. I want it to pull information from that same row and put it on a different page of the workbook. However, this does work. =IF(A24 = "VGK", STATS!AK1:AK32, ""). SO it has to be something i am doing with column B on the STATS worksheet. I think it is trying to add all of the columns up to equal that one cell, but obviously that creates an error, How do I fix this thanks?