From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use the LOOKUP function

Use the LOOKUP function

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Use the LOOKUP function

“

- [Voiceover] As you know we use the LOOKUP functions when we know one piece of data, but don't know the corresponding value. For instance, you may know the student's ID number and want to know his name or her GPA. In this video we're going to learn how to use the VLOOKUP function and the HLOOKUP function. I'll also give you a chance to practice on your own during the chapter four challenge, because you may see a task or two regarding LOOKUP functions on the MOSS Expert exam. I have the 0403 exercise file open, let's get going. Lets look at the data we have, our 2017 student roster has all of the information that we would need to know about each of our students. We have a photography roster VLOOKUP where we need to look at the ID number for each student and pull the student's last name in. We also have a teaching staff worksheet that has the teachers with the classes that they teach in a horizontal layout. On the teaching staff HLOOKUP worksheet, we're going to use a HLOOKUP to look…

Contents