Lookup/Reference: XLOOKUP

Introduction

The XLOOKUP function is a powerful search tool that allows users to find particular values from a range of cells. The XLOOKUP function is a replacement for VLOOKUP and HLOOKUP. This function can help look for information from one column and return results from another column in the same row. The XLOOKUP function is a lookup function that allows users to search for information from one column and return an exact or approximate result from another column in the corresponding row. XLOOKUP can also support wildcards if there is a partial match. Hover over the components of the VLOOKUP formula below to learn more about its inputs.

Functions

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

  • If_not_found, match_mode, and Search_mode are all Optional arguments.

OR

=XLOOKUP(item to look up, the area to search for the item, the area to search for the return item, [value to return if not found], [value to return for match types], [order of search])

Uses

The XLOOKUP function allows users to quickly find particular values from a range of cells. Some examples include:

  1. Look up how many students from a university are from a certain country
  2. To check how much a student has scored on an exam using the name of the student.

Conclusion

The XLOOKUP function allows you to search for information from one column and return an exact or approximate result from another column in the corresponding row. XLOOKUP can also support wildcards if there is a partial match.

css.php