Hello, I'm new here , kinda new to difficult things on excel so I have a question, I think its possible but I don't know how to do it.
I'll take this example, I made standings at football on England Premier League, I have 2 different standings, one for Home,one for Away and I have the score from each match . For example:
Home:
Arsenal 3-0 3-1 1-1 2-1 and so on
Chelsea 2-1 1-0 4-0 3-2 ...
Away:
Watford 1-1 1-2 3-2 1-2 ..
I have 20 teams on home standing and same 20 on away, now in same sheet I have a table with Home vs Away and its incompleted,and here is the thing,lets see this time is Arsenal vs. Watford , is it possible when I write Arsenal on ticket I have below, excel can copy me all values from Arsenal(Home standing) and when I write Watford to copy me all scores from Watford away?
I dont know how but something like when I write Arsenal copy B2:B10(all scores) dont know if I explained well,let me know if you dont understand something. Thanks.
Bookmarks