how to create list in excel using formula?
["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.']