is it possible to a vlookup on a entire workbook? if so how?

I have found the help section of Excel answers almost anything I ask.