Contact Lists and Formulas

Cassie Hart

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"))))))

Thank you!

L_123

In order to have it output as a contact you need to reference a contact cell. On the same sheet or another sheet you need to have a list of potential numbers in one column, with the associated name in a contact column next to it. You can use this table to lookup and return contacts as a contact value using an index match.

=index(contactrange1:contactrange10,match(Name1,NameRange1:NameRange10,0))

L_123

In order to have it output as a contact you need to reference a contact cell. On the same sheet or another sheet you need to have a list of potential numbers in one column, with the associated name in a contact column next to it. You can use this table to lookup and return contacts as a contact value using an index match.

=index(contactrange1:contactrange10,match(Name1,NameRange1:NameRange10,0))

Cassie Hart

Thank you!