Assignment no.7 Use of vlook formula in exvel

 VLOOKUP

VLOOKUP works by searching down the first column of a table to find a match. Once it locates that match, it retrieves data from the specified column of the same row. 

FORMULA:=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

                                      Step 1:LOOKUP VALUE                           

The lookup value Select the cell where you want the result to be and start the VLOOKUP formula by typing:


STEP 2 : Table array

 Now Excel asks you to write the second argument into the VLOOKUP function: the table_array.

This range must contain both the column you’re looking in and the column you want to return something from.



Step 3: Column index number


The third argument of the VLOOKUP syntax is the col_index_num (column index number).

The column index number tells VLOOKUP which of the columns in the table array (from step 2) you want to return a value from.

Step 4: Exact match or approximate match

The fourth argument of the VLOOKUP function is the range_lookup which decides the lookup “mode”.

Most of the time you’ll need to use “exact match mode”. Unfortunately, this is not the default, so you need to let Excel know this with the range lookup argument.

The exact match means the VLOOKUP function will look for exact values exclusively, but it’s important to note that VLOOKUP is not case-sensitive.

RESULT :

Comments

Post a Comment

Popular posts from this blog

Assignment no.4 Filtering in ms excel

Image
  Filtering in MS Excel helps you narrow down your data to show only the information you need. Here's how to use it: *Types of Filters* 1. *AutoFilter*: Automatically filters data based on the column headers. 2. *Advanced Filter*: Allows you to filter data using complex criteria. 3. *Custom Filter*: Enables you to filter data using custom criteria. * How to Apply Filters* 1. Select the range of cells you want to filter. 2. Go to the "Data" tab. 3. Click "Filter" in the "Data Tools" group. 4. Select the column header you want to filter. 5. Choose the filter type (e.g., "Number Filters" or "Text Filters"). 6. Select the filter criteria (e.g., "Greater Than" or "Contains"). 7. Click "OK" to apply the filter . *Filter Options* 1. *Number Filters*: Filter numbers based on criteria like "Greater Than," "Less Than," or "Between." 2. *Text Filters*: Filter text based on criteria li...
Read more

Assignment no.3 Data validation in excel

Image
  Data validation in Excel helps ensure accuracy and consistency in your data. Here's how to use it: *Types of Data Validation* 1. *Whole Number*: Restrict input to whole numbers within a specified range. 2. *Decimal*: Restrict input to decimal numbers within a specified range. 3. *Date*: Restrict input to dates within a specified range. 4. *Time*: Restrict input to times within a specified range. 5. *Text Length*: Restrict input to a specific text length. 6. *List*: Restrict input to a list of predefined values. 7. *Custom*: Create a custom formula to validate input. *How to Apply Data Validation* 1. Select the cell(s) you want to validate. 2. Go to the "Data" tab. 3. Click "Data Validation" in the "Data Tools" group. 4. Choose the validation type from the dropdown menu. 5. Set the validation criteria (e.g., minimum and maximum values). 6. Click "OK" to apply the validation. *Additional Options* 1. *Input Message*: Display a message when a u...
Read more