Using Formulas to extract data

[Lensmeister]

Morning all,

I have a VERY large database of results for a club.

I want to be able the extract the results and info from the Data tab and show it on a separate sheet. I have the main bit set up like:

• a named range for the teams played against
• The area and sheet I want the results displayed
• The data validation list dropdown to select the team

Now comes the problem. I have tried to look up how to do this on YouTube and google and looks like I need to be using things like Index, match, vlookup and combining them in to one big functions but I've gotten more confused the more I read and watch.

I have attached a sample of data in excel and I have put annotation in a text box for clarity.

Can someone help please ?

Thanks in advance,

N.

EDIT: I am open to it being a vba if this will be better to search and help stop the excel taking an age to open.