VLookup & HLookup in Excel 365
Channel:
Subscribers:
4,790
Published on ● Video Link: https://www.youtube.com/watch?v=AeZbESmcq94
1In this video we look at how to do Vlookups and Hlookups in excel.
In Excel every cell has its unique cell reference. For example A1, H30 or D3.
We can use these in formula.
When used in a formula the cell reference is either:
A relative cell reference / Named Value
Or
An absolute cell reference
VLOOKUP is a function that performs a vertical look up of data.
Should be used when the data you want to look up is stored vertically.
HLOOKUP is a function that performs a horizontal look up of data.
Should be used when the data you want to look up is stored horizontally.
Music from Bensound.com
Other Videos By Tech Head Online
| 2020-02-17 | Database Basics in Microsoft Access |
| 2020-02-17 | Charts and Graphs in Excel |
| 2020-02-17 | Conditional Formatting in Excel |
| 2020-02-17 | Data Validation in Excel |
| 2020-02-17 | Sorting and Filtering in Excel |
| 2020-02-16 | Printing Worksheets in Excel |
| 2020-02-16 | Manipulating Text in Excel LEFT, RIGHT, MID & CONCATENATE |
| 2020-02-13 | IF Functions for IGCSE ICT |
| 2020-02-13 | Nested IF Functions in Excel |
| 2020-02-13 | COUNT functions in Excel |
| 2020-02-13 | VLookup & HLookup in Excel 365 |
| 2020-02-11 | Formatting a Spreadsheet in Microsoft Excel |
| 2020-02-11 | Microsoft Excel Basics |
| 2020-02-09 | Spell check and Replace in Word 365 |
| 2020-02-09 | Hanging Paragraphs in Word 365 |
| 2020-02-09 | Inserting and Editing Images into Microsoft Word 365 |
| 2020-02-09 | Creating Tables in Microsoft Word 365 |
| 2020-02-09 | Microsoft Word Creating Columns and Page Breaks |
| 2020-02-09 | Microsoft Word Mail Merge #2 Displaying Field Codes |
| 2020-02-06 | Microsoft Word - Applying Heading Styles |
| 2020-02-06 | Microsoft Word - Heading Styles |
Tags:
excel
office
microsoft
365
excel 365
vlookup
hlookup
cell
cell reference
relative
named range