Put a Vlookup in the managers column
Something like =(vlookup,a1,f:g,2,false) where cols f and g contain team and manager table and a1 has the team.
@moocher started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Put a Vlookup in the managers column
Something like =(vlookup,a1,f:g,2,false) where cols f and g contain team and manager table and a1 has the team.