XLOOKUP Flashcards
1
Q
XLOOKUP Function Syntax
A
=XLOOKUP(lookup_value, lookup_array, return_array, [not_found], [match_mode], [search_mode])
2
Q
XLOOKUP Function Use
A
The XLOOKUP function searches a range or an array, and then returns the item from the corresponding array.
3
Q
How to use XLOOKUP to return multiple columns?
A
- The columns must be next to each other
4
Q
What are wildcards in Excel?
A
A wildcard is a special character that lets you perform “fuzzy” matching on text in your Excel formulas.
5
Q
What are the three uses if the wildcard “*” in Excel?
A
ABC * Sarts with ABC
* ABC Ends with ABC
* ABC * Contains ABC
6
Q
syntax of VLOOKUP
A
VLOOKUP(lookup_value, table_array, col_index_num)
