Function to retrieve values on second tab from tables on the first tab

[viewotst]

Good afternoon,

I hope you are well.

I have a workbook with two different sheets: Stats and Function.

On the stats sheet I have three different tables that I have been given names with the stats of three different teams.
On the second sheet I want to get a formula that gives me in the cells D6, E6 and F6 the values of the references in DE5, E5 and F5 for both teams, local and away.


Can you please help?


Thanks

[Glenn Kennedy]

1. Where do you tell Excerl which teams to look at?

2. Popuate the sheet with expected reults, as I do not follow your explanation!

Ta...

[wk9128]

First convert ranges(D4:F31) attachment text numbers to real numbers
worksheet or Tab name : Function
Change the content text of cell B6 to Local to Home

Cell D6 formula , Drag down and across

Please Login or Register  to view this content.

[viewotst]

Thank you, it works

[wk9128]

@viewotst You're Welcome. Glad to help . Thank You for the feedback