From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Solution: Master VLOOKUP

Solution: Master VLOOKUP - Microsoft Excel Tutorial

From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas

Start my 1-month free trial Buy for my team

Solution: Master VLOOKUP

“

(bright music) - [Instructor] Okay, how did you do? Don't worry if you didn't get the answer, because we're going to go over that together right now. So here I'll select gross revenue for my metric. Now, let's populate our answer. So I'll start by typing equals, Vlookup, open parentheses. Now I'm being asked for my lookup value, which is this cell right here. Next, I'm being asked for my lookup range. I'll go ahead and select the entire table as such. Now I'll hit comma, now I'm being asked for a column index. Let's count together how many columns till we get to 2024. One, two, three, four, five, six. Lastly, and this is an important step, we need to enter in our match type. We want this to be an exact match, so I'll enter zero. I'll close my parentheses and hit enter. And there you have it, the value for gross revenue in 2024. I can now toggle gross revenue to find other values for other metrics in 2024 as such. Way to go on solving your first challenge and making it through the…

Contents