Nesting formulas basing on drop down

[gko_87]

I am attaching three workbooks as follows:

1. All Matches – calculations are based on all home and away matches
2. Last 5 – calculations are based on the last 5 home and away matches.
3. Two in one – This is where the tables above will be merged.

Required on the 3rd table:

There is a drop down in cell Y2 which 2 options (All matches and Last 5). I need to have only the 3rd table where it will pick formulas in the workbook “Calculations” when Y2=All Matches and pick the formulas is the workbook “Last 5” when Y2=Last 5.

I will appreciate all the help I can get. Thanks in advance.

All Matches.xlsx

Last 5.xlsx

Two in One.xlsx

[JohnTopley]

I thought this had been solved ????


https://www.excelforum.com/excel-for...down-list.html

[gko_87]

It wasn't John, I was still getting inconsistent results.

[AliGW]

Duplicate thread closed. Please continue in your original thread: https://www.excelforum.com/excel-for...down-list.html