vlookup

How to use XLOOKUP in excel: Understanding it with 3 examples

How to use XLOOKUP in excel

XLOOKUP is used to search a range or an array and then return a value matching to the condition irrespective of the column direction. It is an extension of vlookup wherein we could get value from one direction only. XLOOKUP has more flexibility with itself as compared to vlookup.

Let us understand the syntax of XLOOKUP:

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Arguments of XLOOKUP:

Arguments Description
lookup  [Required]The value to search for.
lookup_array [Required]The array or range to search.
return_array [Required]The array or range to return.
not_found [optional] Value to return if no match found.
match_mode [optional] 0 = exact match (default),
-1 = exact match or next smallest,
1 = exact match or next larger,
2
Continue Reading

How to use HLOOKUP in Excel

How to use HLOOKUP in Excel

HLOOKUP is one of the functions provided by Microsoft Excel which helps us find a value for a particular reference value. Its functions are the same as VLOOKUP, just the difference exists in terms of fetching data horizontally instead of vertically.

This formula also requires 4 inputs as mentioned below:

HLookup1
How to use HLOOKUP in Excel 7
How to use HLOOKUP in Excel
How to use HLOOKUP in Excel 8

We will take an example to understand this in a better way. As we see in the below table we have data for student’s marks achieved in different subject. Now if I wanted to fetch data for a particular student for a particular subject then we will use HLOOKUP to … Continue Reading

How to use VLOOKUP function in excel | VLOOKUP formula in excel with example

How to use VLOOKUP function in excel

Excel Vlookup is the most sought formula in excel and is widely used by everyone. It is used basically for looking up values vertically means from the column.

Before learning how to use vlookup excel we need to understand about different inputs of excel vlookup formula. As we can see below picture there are 4 different inputs required for using excel vlookup function.

How to use VLOOKUP in excel
Vlookup formula

The explanation of values are given as given below:

How to use VLOOKUP in excel
How to use VLOOKUP in excel

Let us understand this by and example.

In the below table we can see the name of the person and sales done by them on the month on month basis. Now we wanted … Continue Reading