Thread: Vlookup WorkTabs + Vlookup within WorkTabs

I currently have a spreadsheet which has a summary page as the first sheet. I need help retrieving data from the mutiple tabs within the workbook.

Basically the summary area will do a vlookup or some sort of way to identify which tab to go into. Once it has found the correct Tab it will do another look up to search which category is the data I am looking for.

I.E. - In the summary page I would to search for "Manager A" Tab and then search for the category "Two Pager" and then give me the data that is located there for instance "X" or "Missing"

Please see attachment

Thank you very much for your help I greatly appreciate it beforehand.

Cheers,
Daniel

I have looked at your wookbook and have a few questions...

Instead of having each manager on a seperate worksheet (tab), could you put them all on the same worksheet? then each column could be for a manager, and looking up the data you want migt be easier>

Perhaps im not understanding your requirements? It seems to me that you dont even need a vlookup, a simple reference (=A!G12) would give you the info you need in your summary?

To clarify my inquiry. Basically the managers will change. So I want to just use the Summary tab to pull in all the information from the manager tab. So the Manager tab could later be "F" "G" "H" "I" Manager name. So all I would do is enter the Manager name in the first column on the SUmmary page and the information would be retrieved.

Also the managers will need to be on separate tabs.