Hey everyone,
I have a SharePoint site with two lists. One is the 'form' list and includes a bunch of different columns required for the form. The other list is made specifically for lookup purposes and includes a column for purchasing groups and another column for what buyer leads each purchasing group. The form is aimed to complete an order requisition for a client. The place I am stuck is that when a user picks a purchasing group, I want a calculated value to retrieve the buyer associated with that certain purchasing group.
Refer to the picture below for a better idea of what I am trying to accomplish.