From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Look up data using VLOOKUP() and HLOOKUP()
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Look up data using VLOOKUP() and HLOOKUP()
- [Narrator] Let's talk about two basic functions in Excel where you can look up data either vertically or horizontally. Vertical and horizontal lookup have been used in Excel for years, and it may not be your first choice or your go to, but you may come across a question on the exam that asks you to use a lookup function to find a particular result. So, we're going to take a look at both VLOOKUP and HLOOKUP. Here is our LOOKUP workbook. And we'll start with the HLOOKUP. So remember, this is a horizontal lookup, which means Excel is looking horizontally at the information. If we want to find the sales for B&B Spaces, we will begin by typing HLOOKUP, we'll Tab to step into that. Now, if you find it easier to work in the Function window, you can always click the fx button to the left of the formula bar and come right in and enter your arguments here. So, what is the LOOKUP value? Well, in this case, it's B&B Spaces. The…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Use AND(), OR(), and NOT() in nested functions6m 9s
-
Use IF() and IFS() in nested functions4m 31s
-
(Locked)
Use SWITCH() in nested functions3m 38s
-
Use SUMIF(), AVERAGEIF(), SUMIFS(), and AVERAGEIFS() functions5m 2s
-
(Locked)
Use COUNT() and COUNTIF()2m 54s
-
Use MAXIFS() and MINIFS() in nested functions3m 27s
-
(Locked)
Look up data using VLOOKUP() and HLOOKUP()5m 52s
-
Use the MATCH() and INDEX() functions5m 47s
-
(Locked)
Use NOW() and TODAY() functions and calculate dates using WEEKDAY() and WORKDAY() functions8m 15s
-
(Locked)
Summarize data from multiple ranges by using the Consolidate feature3m 10s
-
(Locked)
Use What-If Analysis Goal Seek and Scenario Manager5m 57s
-
(Locked)
Calculate financial data with NPER() and PMT() functions3m 30s
-
(Locked)
Troubleshoot formulas9m 24s
-
(Locked)
Challenge: Create advanced formulas27s
-
(Locked)
Solution: Create advanced formulas9m 8s
-
-
-
-