how to resolve blank error

Hi Team,
Please see the attached file where I get the vlookup data in multiple columns and I have to sum all columns no.'s but I am facing a problem after vlookup (please refere Q6009 cells it seems blank but when you cursor down from Q column it stop in cell Q6009) that's why it shows error while I do sum of all cells (a6009, b6009 --- -- -q6009)

please do let me how to resolve this type of issue