Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stumped - multiple lookup criteria across worksheets
I have 100 plus sheets in a workbook.
Each has the same layout for data entry. Each sheet tab is the name of an employee. In (B1:B10) I enter a date. In (C1:C10) is data I need to display on a master sheet called "Roster". The Roster sheet in A13:A20 will contain the names of employees as an example. A1 in the Roster sheet will have the current date. How can I match the name in A13 of the Roster with the Date in A1 of the Roster and return the corrosponding data by date from the worksheet of the employee in A13. This value is displayed on the Roster sheet in B13. I am stumped. Thank you, Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
lookup for criteria from either of 2 worksheets. | Excel Discussion (Misc queries) | |||
Stumped on Lookup Function | Excel Discussion (Misc queries) | |||
Stumped by a lookup scenario | Excel Worksheet Functions |