assignment 6

-

 USE OF VLOOKUP IN EXCEL 

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 OF VLOOKUP

=VLOOKUP(lookup_value,table_array,column_index,range_lookup)





STEPS:

  1. Identify which is the value that you want to use (finding the lookup value)


  2. Understand for which data to perform the VLOOKUP (selecting the table array)
  3. Select which info you wish to retrieve 
  4. Determine if you need to use an exact or approximate match (setting the match type)

OUTPUT: 







Comments

Post a Comment

Popular posts from this blog

ASSIGNMENT NO.5

-
Image
HOW TO USE FLASHFILL IN EXCEL Flash Fill is one of the most amazing features of Excel. It grabs a tedious task that would take hours to be performed manually and executes it automatically in a flash. And it does so quickly and simply without you having to do a thing but only provide an example of what you want. step 1:-   Enter the  First Name  in the first result cell and press  Enter . step 2:- Start  typing the next name step 3:-  Flash Fill  will suggest the  first  part of all names  step 4:-  Press  Enter . step 5:- You can see all the  First Names  in column  . step 6:- Separate the surname  Names
Read more

ASSIGNMENT NO.1

-
Image
  How to make pivot table? Creating a pivot table is a great way to summarize and analyze data in Excel or Google Sheets. Here's a step-by-step guide on how to create one: Select Your Data : Highlight the range of data you want to use for the pivot table (including headers). Insert Pivot Table : Go to the Insert tab on the ribbon. Click on PivotTable . Choose Pivot Table Location : Excel will ask if you want to place the pivot table in a New Worksheet or an Existing Worksheet . Choose one based on your preference. Click OK . Add Fields to the Pivot Table : A PivotTable Field List will appear on the right side. Drag and drop the fields (columns from your data) into one of the four areas: Rows : This will categorize your data into rows. Columns : This will categorize your data into columns. Values : This will calculate the data, like sums, averages, counts, etc. Filters : This allows you to filter the data based on certain criteria. Adjust and Cus...
Read more

ASSIGNMENT NO.2

-
Image
  R emoving duplicates in excel: The Remove Duplicates function is used to remove duplicate entries. Duplicate entries are values that two or more are the same. This can be both numbers and text inputs. A1 and A2 are duplicates since they have the same values. Select the range where you want to remove duplicate values. 1. Select Your Data: Highlight the range of cells where you want to remove duplicates. You can select a column or a table (multiple columns and rows) based on your needs. 2. Open the "Data" Tab: Go to the Data tab in the Excel ribbon at the top of the window. 3. Click "Remove Duplicates": In the "Data Tools" group, click the "Remove Duplicates" button. 4. Choose Columns to Check for Duplicates: A pop-up window will appear where you can choose which columns to check for duplicates. By default, Excel will check all columns that are part of your selected range. If you want to remove duplicates based on one specific c...
Read more