What are VLOOKUP and HLOOKUP Functions in Excel?

Download the free practice Excel file for this video from www.goskills.com/Excel/Resour...
Let’s explore VLOOKUP vs HLOOKUP in Excel. In this video you'll learn how these functions work, and when to use them.
The HLOOKUP and VLOOKUP functions are grouped in the lookup category of functions. The function looks for a certain value in the first row (HLOOKUP - (h)orizontal) or column (VLOOKUP - (v)ertical) of a table and returns any value from the same column (HLOOKUP) or row (VLOOKUP).
Skip to:
0:00 - Introduction
1:07 - VLOOKUP
2:23 - HLOOKUP
--
Learn more with the full Excel course on GoSkills: www.goskills.com/Course/Excel...
--
Subscribe to our RUclips Channel for more tutorials and webinars: / @goskillscourses
#VLOOKUPvsHLOOKUP #MSExcel #ExcelTutorial
--
For more updates follow us on:
- Facebook: / goskills
- LinkedIn: / 3053820
- Twitter: / getgoskills
- Instagram: / goskills
- Website: www.goskills.com/?...
--
Video content by Lydia Uys, and presented by Dan Gorgone for GoSkills

[@ucjabaszczyk6881]

nice :) thanks!

[@GoSkillsCourses]

Any time!

[@mikeydan]

not sure if you will see this or not but... why include all three fields in the 2nd part of the sheet and only return one column of data? I thought by including first and last name in the table array (and for some reason you have workshop ID) that it would return both first and last name in the first half of the sheet. how would I bring over last name?