Contact Lists and Formulas
Hello! I am new to spreadsheet formulas so apologies for missing what could potentially be very simple. I am trying to write a formula that will auto select the right contact if a certain number is inputted into another column hence auto-assigning a job.
The formula works for inputing the right name, but only as text. Is there a way to have it select the actual contact too so then that contact is updated that a job is for them?
Formula is (but with using the real names):
=IF(Grade1 = "9", "NAME1", IF(Grade1 = "3", "NAME2", IF(Grade1 = "1", "NAME3", IF(Grade1 = "7", "NAME4", IF(Grade1 = "6", "NAME5", IF(Grade1 = "8", "NAME6"))))))
Help Article Resources
Check out the Formula Handbook template!