Introduction to Excel
Security
Short Keys
Practice Data Sheets
Data Formats
Conditional Formatting
Format as Table
Data Sorting
Data Filtering
Remove Duplicates
Data Validation
Text-To-Columns
Data Consolidation
What-if-Analysis
Grouping
Absolute & Relative Referencing
Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
Task1 - Mathematical Formulas
Logical Functions - IF, IFERROR, AND, OR
Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
Vlookup Formula
Task2 - Vlookup Problems
Vlookup with Match Formula - Dynamic Duo
Vlookup using (*) example
Vlookup with Running Countif
Task3 - Vlookup, Running Countif Problem
Lookup Functions - Hlookup, Index Match
Lookup Functions - Indirect, Offset
Vlookup-Indirect Example
Sumif, Indirect, Offset, Match Example
Array Functions
Task4 - Array Problem
Advanced Conditional Formatting using Formula
Data Validation using Indirect Function
Charts, Waterfall Graph
Pivot Table, Dashboards

Powered by GitBook

On this page

Was this helpful?

Task2 - Vlookup Problems

PreviousVlookup Formula NextVlookup with Match Formula - Dynamic Duo

Last updated 6 years ago

Was this helpful?

Solve the attached Vlookup problems.

Problem - 1 :

Using ABC_Master sheet, solve the ABC_child sheet (Task1 and Task2)

Problem - 2 :

Using XYZ_Master sheet, solve the XYZ_child sheet (Task1)

Problem - 3 :

Replace the Lead_Source_Id, Prospect_Id, Source_Id columns in MASTER_DATA with the corresponding ID's in Lead Source, Prospect, Source Workbooks