Xlookup with Wild Card #excel2024

Create a Search Pattern by using Wild Card with Xlookup.

Here's the breakdown of the formula:

"*"&E13&"*": This part of the formula concatenates the asterisks (*) with the content of cell E13. This effectively creates a wildcard search pattern where the text in E13 can appear anywhere within the searched values. For example, if E13 contains "apple", then "*"&E13&"*" becomes *apple*.

D2:D11: This is the array or range where Excel will search for the value specified in the first argument ("*"&E13&"*").

D2:F11: This is the array or range from which Excel will return the corresponding value when it finds a match. The value returned will be from the same row where the match is found, but from the column specified here. In this case, it will return the value from column E (the third column in the range D2:F11) where a match is found.

, (Comma): This is used to separate the different arguments of the XLOOKUP function.

2: This is the match mode parameter. It specifies the type of match to be performed. In this case, 2 indicates a wildcard match. This means that the function will look for the value in the first argument as a wildcard pattern within the values in the search array.

__________________________________

Don’t forget to Save & Share with your Friends 🫂

✅ Follow @excelonlineadvisor for Excel related Videos.

🆓 Assitance provided for any Doubts in Excel 📑