How to find Uncertain Values Through Wildcards with XLOOKUP in MS Excel by Computer Geek. Video-2
Wildcards with XLOOKUP; How to find Uncertain Values in Excel with by typing a few keywords. Video-2

Use the XLOOKUP, the new versatile multipurpose function, is a function when you need to find things/values/information in a table or a range by row. For example, look up the account name of account by the account id, or find a student name based on their student id or roll no. With XLOOKUP, you can look in one column for a search term, keywords, wildcards etc, and return a result from the same row in another column, regardless of which side the return column is on which means unlike vlookup and hlookup (which look or search to right only), the xlookup can search both at the right and left. This effectively reduce the use of or get rid of the index - match functions combination altogether.

свернуть