Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLOOKUP or THREED for summary
Hi,
I Have 20 worksheets in a seperate workbook all in exactly the same format and containing weekly data on 30 individuals. On a summary sheet, at the moment I am using VLOOKUP to match a persons name when entered in cell F2 and return a particular variable for a specific week in the other workbook. This is what I am using =VLOOKUP(F2,'[Heart Rate.xlsx]Week 13'!$C$7:$NF$90,9,0) What I would like to do is add another dimension to this formula so I can avoid having to predefine the week in the formula and instead use another cell on the summary sheet to also lookup a designated week before returning the required person variable. (more in the form of 'Week 1:Week 20'. Is there any way to do this? Many thanks in advance for your time. Kind regards, Ant |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLOOKUP or THREED for summary
Just to bump the thread,
If anyone could provide any help or experience, it would be brilliant. Cheers guys, Much appreaciated, Ant. "Anto111" wrote: Hi, I Have 20 worksheets in a seperate workbook all in exactly the same format and containing weekly data on 30 individuals. On a summary sheet, at the moment I am using VLOOKUP to match a persons name when entered in cell F2 and return a particular variable for a specific week in the other workbook. This is what I am using =VLOOKUP(F2,'[Heart Rate.xlsx]Week 13'!$C$7:$NF$90,9,0) What I would like to do is add another dimension to this formula so I can avoid having to predefine the week in the formula and instead use another cell on the summary sheet to also lookup a designated week before returning the required person variable. (more in the form of 'Week 1:Week 20'. Is there any way to do this? Many thanks in advance for your time. Kind regards, Ant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using THREED function with VLOOKUP to sum across multiple workshee | Excel Discussion (Misc queries) | |||
Help with vlookup results for summary | New Users to Excel | |||
Summary of multiple sheets | Excel Worksheet Functions | |||
Summary sheet with Vlookup | Excel Worksheet Functions | |||
Multiple Workbooks Summary | Excel Worksheet Functions |