vlookup function return all values

[Domenic]

After all that, when I hide the sheets with the data numbers on it, my
functions on my first sheet dont return anything. Is there a way to hide the
sheets and still use the information?

As far as I know, hiding sheets shouldn't affect your formulas. If
you'd like, I can send you a sample file.