INTERSECT in Excel

[Anne Troy]

Like a multiplication table, I need to find a value based on both the top row and left column. Excel doesn't have the INTERSECT formula anymore? Or maybe I just lost my head? Thanks for your help, guys.

[Bob Phillips]

It doesn't work off of just the headers, you specify the whole row and column, like

=A2:C2 B1:B10

or

=2:2 B:B

[Anne Troy]

Okay, so that doesn't appear to be my problem after all. I'm not sure how to design this...

We want a workbook where each user has their own worksheet.
The admin creates a specific workout regimen, such as 15 pushups, situps and squats.
That's for medium intensity. There is also Light and Heavy intensities.
Then, there is up to 100 different exercises.
He wants to, for instance, create a week's worth of cycles in advance. The user opens the workbook and chooses their intensity, and it's populated for the cycle for that day that he created. I can't work it out how I'm gonna get:
Name
Intensity
Exercise
Reps
Any suggests?

[JeffreyWeir]

Anne: If you post a sample spreadsheet with some examples of what you want to achieve, then I'm sure someone can help you out.

[Anne Troy]

Okay, I posted, but the file was incomplete. I'll fix it up and upload. Thanks!

[Zack Barresse]

Was it deleted again? I dont' see it now.. ?

[JeffreyWeir]

Something like this? Range retrieval.xlsx
Or do you want the user to be able to select a different intensity each day?

[Zack Barresse]

This sounds like it should be in Access...

[Anne Troy]

LOL That's what I told him. The thing is, he doesn't even have Excel. He originally wanted Googledocs (again), but it barely doesn't a data validation.

Thanks, guys. Sorry. I'm suggesting a web-based app with MySQL, which I may actually learn.

[Anne Troy]

And I heard you laugh just then, Zack.