HI
As a very early learner! to excel formulas - any advise offered greatly appreciated.
I have a worksheet which uses formula to import data (Football results) from another worksheet,within the workbook, which show's column data in a specific row order.
Column a / row 1 - a1 - is a specific football team name
column b - row 1 informs if the game is H or A - Home or away (this is determined if a1 matches either b2 or b5)
b2 - shows away team name
b3 - shows the home team result
b4 - shows the away team result
b5 - shows home team name
I want to show in b6 the result of the team named in a1 - irrespective of it being H or A game, and then in b7 the result of the opposing team - again irrespective of it being a H or A game - keeping the data in b1 to b5 unchanged.
This would then be applied to subsequent games played in adjacent columns.
Thanks for any help offered.