A
Anto111
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
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