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,
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:

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