From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Join today to access over 24,900 courses taught by industry experts.
Challenge: Master HLOOKUP - Microsoft Excel Tutorial
From the course: Mastering Lookup Functions in Excel: Seven Powerful Formulas
Challenge: Master HLOOKUP
(upbeat music) - [Instructor] Let's now jump into our next challenge to help us master HLOOKUP. Here I have a balance sheet, and this time, my input is the year rather than the metric. I want to be able to get the value for inventories for whichever year that I specify over here. Do you think you can solve it? Good luck.
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.