I have three columns with large amounts of data
Column A: Office Location, Column B: Coordinator Name, Column C: Ops Manager Name
In cell D1 of my spreadsheet, i have a dropdown list that has all the office locations
I choose the location
Cell E1 needs to be a formula that shows me who the coordinator is for the location I selected
Cell F1 needs to be the Ops Manager for that location.
I need cells E1 and F1 to auto populate based on the location that I selected
any help would be greatly appreciated!
Thanks
Column A: Office Location, Column B: Coordinator Name, Column C: Ops Manager Name
In cell D1 of my spreadsheet, i have a dropdown list that has all the office locations
I choose the location
Cell E1 needs to be a formula that shows me who the coordinator is for the location I selected
Cell F1 needs to be the Ops Manager for that location.
I need cells E1 and F1 to auto populate based on the location that I selected
any help would be greatly appreciated!
Thanks