You have a table of data listing each sales person in one column and their territory in a second column. Each sales person is only listed once but there are hundreds of sales people. What function could you use to quickly display a salesperson's territory by typing in their name?

🎲 Try a Random Question  |  Total Questions in Quiz: 719  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Excel Fundamentals Test (Upwork) — practice the complete quiz, review flashcards, or try a random question.

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.


You have a table of data listing each sales person in one column and their territory in a second column. Each sales person is only listed once but there are hundreds of sales people. What function could you use to quickly display a salesperson's territory by typing in their name?