Hi,
First you would need to rename the Inside Rep respective named ranges to include the last name, but do not include the space (as it isn't allowed).
So the name range, Paul becomes PaulNoble.
Then the data validation formula for column G (Regional Manager) becomes: =INDIRECT(SUBSTITUTE(F2," ",""))
Bookmarks