excel dropdown list selected vlookup to another value
I have a workbook with a couple tabs and one has drop down lists that connects to other tabs to prefill the dropdown list.
so on my main tab column B is a drop down which selects data from TAB(Territory) Column A. When the user selects on of the drop downs I also want Column C of the current tab to be filled with the corresponding Column B from Territory. Is there a built in or vlookup?