I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell.
Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1 and have their name automatically appear in B1.