=IF(ISBLANK($A$66:$A$543),"",(IF(ISBLANK(E$2),"",(VLOOKUP($A$66:$A$543,Sheet1!$A$4:$AA$397,HLOOKUP($B$2:$AI$2,Sheet1!$B$1:$Z$2,2,FALSE),FALSE)))))
Above is my formula. This formula is on my report page. My sheet1! is where we enter the data needed for the report. The only thing that seems to be...