Question: how to make a list formula in excel?
Answer: Type a team name into cell G2 (e.g. 'Admin' has been entered into the spreadsheet below);
Insert the following formula into cell E1: =$G$2.
Insert the following formula into cell E2: =HLOOKUP($G$2, $A$1:$C$6, ROW(), 0)
Copy the formula in cell E2 into cells E3 - E6.