Unable to get an INDEX MATCH formula to work for a multiple row and column lookup

Hello

I've attached a simplified version of what I'm trying to achieve.

In short, I have a little summary table that will want to look up a date (cell C25) and then the member number (cell B27). From here it will look through row 4 to find the corresponding date and then down column B to locate the member number. I then need it to offset either one, two or three columns to return the respective value for "Location", "Score" and "Time" (cells C27, D27 & E27).

I've had many attempts at playing around with MATCH INDEX and OFFSET from reading a few examples online, but nothing has been successful. Has anyone got some helpful hints on piecing all these functions together to get a solution?
Many thanks!

INDEX MATCH (multiple).jpg

In the attached I've used the below formula in cell C27 to return the name.

Formula:

Please Login or Register  to view this content.

Then by offsetting the columns in the red section you can get the score and time.
So score would be E5:Y5 and time would be F5:Z5.
Then you can copy those formulas down as needed.

Hope that helps.

BSB

Worked absolutely perfectly. Thank you very much!