Description
VLOOKUP is perhaps the foremost used function in excel. This course does only one thing - Demystify how VLOOKUP works in excel. We cover the subsequent aspects of VLOOKUP.
Why use VLOOKUP
VLOOKUP is employed to cross-reference data. There are many situations where data in one sheet or tab must be cross referenced to extract values out of it. for instance , say we've 1000 students data during a sheet. we would like to seek out out the grades of 100 students among them. aside from doing this manually, what else can we do ? VLOOKUP may be a thanks to automate this function in order that we will extract all the knowledge in one go , automatically employing a simple formula.
How VLOOKUP works
There is a selected way during which VLOOKUP works. The parameters utilized in VLOOKUP are confusing initially. This course will cause you to understand the formula along side the parameters with simple examples and with simple data sets.
Approximate vs Exact Match
Sometimes you got to match ranges rather than exact numbers. for instance , within the same students data, how would you match grades (like A or B) to absolute numbers ? That's when approximate match comes in. we'll see the way to do approximate matches with sales commission numbers.
HLOOKUP
VLOOKUP stands for Vertical LOOKUP. Although, this is often the foremost used function, Excel also provides functionality to lookup horizontally. Data typically doesn't tend to the present quite lookup in real world , but nevertheless, we'll cover HLOOKUP.
SQL Equivalent of VLOOKUP
If you understand SQL, we'll check out how VLOOKUP is the same of a specific version of SELECT statement that you simply are going to be conscious of in SQL. If you've got no knowledge of SQL, you'll ignore this part.
Commonly occurring problems.
#N/A error
Number as Text
VLOOKUP works left to right only
Lookup is case insensitive
Named Ranges
If you employ a specific excel sheet tons repetitively, using named ranges are often very helpful. we'll explore how named ranges are often created and utilized in VLOOKUP. This makes formulas look less ugly.
VLOOKUP in Google Sheets
VLOOKUP functionality is provided in Google sheets also . during this quick chapter,we will check out the way to use VLOOKUP in google sheets.
Get Coupon
No comments:
Post a Comment