Use HLOOKUP and VLOOKUP Functions
About the Lecture
The lecture Use HLOOKUP and VLOOKUP Functions by Sonic Performance is from the course Creating Advanced Formulas in Excel 2013. It contains the following chapters:
- Introduction
- The Vlookup Function
- The Hlookup Function
- Summary
Included Quiz Questions
Range A1:A10 is currently named Employee. To change the range name to Associate, you can:
- Open the Name Manager dialog box, select the range name, and then select Edit.
- Select the range, and then type the new name in the Name box.
- Insert a new cell above the range, type the new range name in the new cell, and then select Create from Selection in the Defined Names group.
- Select the range and then, in the Define Names group, select Define Name.
Which category of functions performs what-if and conditional analysis on data?
- Logical
- Statistical
- Engineering
- Lookup and Reference
Author of lecture Use HLOOKUP and VLOOKUP Functions
Sonic Performance
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
