Simple conditional index formula question

[mischifous]

HI everyone,

I have TWO tables, where the A column are the same dates, but the values in columns B and on are different for each table. Both tables have the same # of values for each date (in the columns).

I want to create a formula where for each day, table 1 is referenced and it pulls the top 3 highest numbers from column A, and then averages the corresponding cells from table 2.
SO lets say a random row 400 is day 10/1/2020: Let’s say column B, C & E are the highest values for those days, it would average B,C,E columns in the corresponding row on table 2? Is there a way to do this in one cell? Thanks so much

 

[maabadi]

Please upload example file & Desired Result with XL2BB ADDIN (preferable) or upload at free hosting site: e.g. www.dropbox.com , GoogleDrive or OneDrive & Insert Link Here.