ASSIGNMENT 7

-

USE OF HLOOKUP IN EXCEL

In Excel to find and extract data from a table. By the end of these steps, you’ll be able to look up values horizontally across rows with confidence.

Step 1: Open Your Excel Spreadsheet

First, open your Excel spreadsheet where your data is stored.

Make sure your table is well-organized with the necessary data laid out in rows. This organization is crucial for the HLOOKUP function to work correctly.

Step 2: Select the Cell for the HLOOKUP Formula

Choose the cell where you want the result of the HLOOKUP to appear.

Click on an empty cell, which will be the destination for your lookup result. This will help you keep your data organized.

Step 3: Enter the Hlookup  Formula

In the selected cell, type .=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Step 4: Press Enter

After entering the formula, press Enter to execute it.


 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