I am trying to streamline my tracker in Excel. I recruit for candidates throughout Washington, Oregon, Idaho, and Arizona. Theres a total of 60 stores I am recruiting for. Each of the stores are assigned with a unique number for tracking purposes. Currently when I add a new candidate to the tracker, I have to manually add the store information that they had applied to in my tracker. I am hoping to be able to just add the store number and have the other fields in Excel auto populate with that stores information such as the address, City, State, Zip, store MGR, area MGR, Market MGR, Starting Pay
Solved by X. W. in 27 mins