vlookup issue and multiple selections
I'm using a form to collect headcount changes at locations we manage. I'm using a vlookup to autofill the site managers name based on the site location chosen. However, I've run into an issue when the person filling out the form selects more than one location (selected via drop down multi-select list).
If the headcount being reported is shared among 2 sites, those sites will always have the same manager. Is there a way to rewrite the formula so I don't get an error? Maybe only look at one item in the selection rather than both?
This scenario will not happen very often and I thought maybe I could just overwrite the site manager cell in those instances, but I'm using a column formula so the vlookup happens automatically when new entries are made via the form.