Multiple VLOOKUP or THREED for summary




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,





Just to bump the thread,

If anyone could provide any help or experience, it would be brilliant.

Cheers guys,

Much appreaciated,


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question