I am working on a roster on sheet one that has in column A: rank (Captain, Major, Sergeant), column B: last name, and column C: first name. What i am trying to figure out is how to have those names filled in automatically based on their rank on another sheet?
Bookmarks