Hi, Data Sheet has 4 Columns
Column One has employee names Column Two has salary specific to the employee in Column One Column Three has job titles Column Four has starting salary specific to job title When completing a spreadsheet a person would enter an employee name in cell A1 and then job title in cell A2. I would like to create a formula that would populate cell A3 with salary data for the employee (A1) based on matching the name in Column One. If the employee's name doesn't exist in Column One I would like instead to populate cell A3 with starting salary for the job title (A2) based on matching the titles from Column Three. Thanks, Helder -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
