Help updating a field by matching one value then depending on that perform another match

[Bigjohnj]

I have 3 sheets. CONFIG has all the team number, name and players. FIXTURES has date then lists week No., Team Numbers (highlighted) and which lane they are playing on. Results Sheet where i want to select a date and update the fixtures for that week.

View attachment 92649

CONFIG FIXTURES RESULTS
What i am looking to achieve is :-
On the results sheet (D1) i am creating a list ( Data Validation ) which will lookup the dates on the Fixture list Column A. I have selected week 1 for the example.
Depending which date i select i then need to select the fixture team number (1 which is highlighted) then lookup that number on the config sheet (row 2) and select the team name from Config (Row 3) (The Vets)

I have it working not based on the date but then this is static and not dynamic. =INDEX(Config!$A$3:$O$3,MATCH(Fixtures!C2,Config!$A$2:$O$2,0))

Any help would be greatly appreciated. John

 

[awoohaw]

Welcome to the forum. Mr. Excel has a tool that allows users to post mini workbooks that allow to copy and paste data and formulas into threads. Pasting images while helpful means the forum must completely recreate your scenario which takes time and can have typos which leads to error and more time correcting. The link to get xl2bb add is below.
If you cannot instal because of company restrictions then please post the data as table being sure to label rows and columns and indicating where and describing the formulas you have. You will get a much faster response, and probably multiple responses.

Help the forum help you. Thanks in advance.

 

[Bigjohnj]

This is all the worksheets

 

[awoohaw]

please post the data. either with xl2bb or in pasted tables (with descriptions).