vertical lookup and horizontal lookup

-

🖥️🖥️🖥️

VLOOKUP function in Excel

 


The VLOOKUP function is one of the most popular functions in Excel. This page contains many easy to follow VLOOKUP examples.

Exact Match

Most of the time you are looking for an exact match when you use the VLOOKUP function in Excel. Let's take a look at the arguments of the VLOOKUP function.

1. The VLOOKUP function below looks up the value Anaya (first argument) in the leftmost column of the red table (second argument).



2. The value 2 (third argument) tells the VLOOKUP function to return the value in the same row from the second column of the red table.



Note: the Boolean FALSE (fourth argument) tells the VLOOKUP function to return an exact match. If the VLOOKUP function cannot find the value Anaya in the first column, it will return a #N/A error.

3. Here's another example. Instead of returning the roll no, the VLOOKUP function below returns the last name (third argument is set to 3) of Anaya = 4004.

Full  formula.



🖥️🖥️How to Use HLOOKUP Formula in Excel🖥️🖥️

The HLOOKUP formula is a useful tool for looking up data in tables arranged horizontally. This HLOOKUP tutorial will guide you through the steps to use the function effectively:

Step 1: Prepare your Data

Organize your data so that the lookup value resides in the first row of a range or table. For Example:


Step 2: Choose a Cell to Enter the Formula

Select a blank cell where you want the result of the HLOOKUP function 

to appear. In the below example we have selected D17.


Select a Cell where you want to display the results

Step 3: Enter the HLOOKUP Formula

To look up the names for A3, enter the following formula in your selected cell:

Step 4: Press Enter
After pressing Enter, Excel will return Anisha, which is the value in the second row under “name. 
Select the Cell>> Enter the Formula>> Press Enter

formula of horizontal lookup 



🖥️🖥️🖥️

Comments

Post a Comment

Popular posts from this blog

`Data validation

-
Image
😊😊Data validation for error message😊😊 1. Click on data option in menu bar. 2. Select data tools then go to setting. 3.Choose whole number from drop list. 4. Fill the maximum number. 5. Fill the minimum number. 6. Fill title under error alert option.   OUTPUT   figure1:- figure 2:-  figure 3:- 
Read more

Assignment of removing duplicate data and if condition formula

-
Image
Remove duplicate data 1. Go to data option  in menu bar. 2. Select the data in which you want to remove duplicate items. 3. select the duplicate remove option which is situated next to the columns. Then dialogue box will appear which is shown following below :- OUTPUT:- If condition formula In Excel, you can use the IF function to perform conditional logic. The basic syntax is: = IF (logical test, value_if_true, value_if_false) logical test: The condition you want to evaluate (e.g., A1 > 10). value_if_true : The value that will be returned if the condition is true. value_if_false : The value that will be returned if the condition is false. Example 1: = IF (A1 > 10 , "Yes" , "No" ) If you want to check if the value in cell A1 is greater than 10, and return "Yes" if it is, or "No" if it isn't: Example 2: If you want to check if the value in A1 is greater than 50, and return "High" if true, or "Low" if false, you can d...
Read more

POWER BI

-
Image
  What is Power BI? Power BI is a business intelligence tool of Microsoft that is mainly designed to curate and present data insights that are most intriguing and engaging. It is a versatile tool that can easily derive data origins, including cloud services and Excel spreadsheets. Power BI is used by many businesses to create better visualization of data through charts, graphs, and other data interpretation techniques. Discover the art of Power BI more through the CCSLA exclusive  PL-300: Microsoft Power BI Data Analyst  course to gain valuable insights from industry leaders. Furthermore, Power BI offers data refinement and structuring to enable the development of reports, presentations, and interactive dashboards. The Power BI works at its total capacity to convert data, clean it, and make it more appealing using visual elements. It facilitates sharing and collaboration using cloud services. It helps them to cooperate reasonably in the team and make data-driven decisions...
Read more