| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
V Lookup between worksheets in same file
What is the vertical symbol between Apr and A1? "Joel" wrote: Vlloup won't work across multiple sheets but Sum will. use indirect to get the address and feed it into a sum like this. Mtch will return the row number where the person name was found provided the range starts in row 1. =SUM(indirect("Apr:Jun!A"&match(A5,Apr|A1:A100))) "Alberta Rose" wrote: 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
