| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
V Lookup between worksheets in same file
I'm trying to sum quarterly hours depending on employee name. Employee name resides in column A of each worksheet. I have name defined the areas on the sheets where the data resides as APR MAY JUN. =vlookup(A5, Apr:Jun - what's next???? I want excel to look at the name in cell A5 on each sheet and if there is a match, go to cell B5 and sum, C5, D5, etc. etc. How do I do this? Help please... Thanks, Laurie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup between two worksheets | New Users to Excel | |||
| Lookup between two worksheets | New Users to Excel | |||
| Lookup between two worksheets | New Users to Excel | |||
| lookup for criteria from either of 2 worksheets. | Excel Discussion (Misc queries) | |||
| Lookup across multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
