Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Help
I have a spreadsheet with three tabs.
Tab 1 needs to perform summary calculations Tab 2 & 3 are ODBC connections with source data from other files. Tab 2 is a sql query that is a cross tab with columns 1-4 representing row data and then the remaining columns are employee ids with a productivity value in their column. Not all columns have the same value as they correspond to a job/service performed on a specific date. My problem Tab 1, column 2 contains "completion dates from 1/1-current and refreshes based on tab 2 each time it opens. I need a lookup formula that will read the single date column and say if date begins with December, then total the sum of tab 2 column "X" (for corresponding December values only) and divide by the (total of tab 3 column (X) for the same time frame, and then do it consecutively for all months. I've tried as a lookup and vlookup and neither seem to be coming out right. Any suggestions are appreciated: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions |