#Xloc keyword how to#
#Xloc keyword windows 10#
#Xloc keyword software#
#Xloc keyword download#

When adding wildcards to a function in this way, you must concatenate the delimiter and the reference. You can’t just plug in the asterisk character though. For example, to find the entire product name using only pears as a lookup value, you’d use *pears* as the search string. We’ll be using the asterisk character (*), which finds any number of characters.

#Xloc keyword how to#

However, throwing a wildcard into the mix can! How to add a wildcard in Excelĭon’t worry if you’re not familiar with wildcards, but they are something you should review because they really come in handy. XLOOKUP() wants an exact match, and the current setup can’t get the job done. If you paste the value from column D into I2, the function works as expected, so you know it’s the input value and not the function. If you see a #VALUE error, something’s wrong with the function itself. The error value is a good clue #N/A means the function can’t find the value in I2. (Remember, if you’re not using a Table object, your references won’t look the same because Table objects use structure referencing.)įigure A We’ll need wildcards to find some products by product name. For instance, if you try to find “Uncle Bob’s Organic Dried Pears” by entering only Pears you’ll be disappointed ( Figure A). The next step might be to use XLOOKUP(), which returns a single value based on a lookup value-in this case, the product names as follows: When searching, you might consider filtering or supplying a data validation control, but in both cases, the product list is long and a bit awkward to work with. As you can see in Figure A, the product names are a bit complex, and it might be difficult to remember them exactly. Let’s suppose that you use Excel to track products for a gourmet food distributor. This article assumes that you have basic Excel skills, but even a beginner should be able to follow the instructions to success.

#Xloc keyword download#

For your convenience, you can download the demonstration. Excel’s XLOOKUP() function is available in Microsoft 365 and Excel 2021, and Excel for the web.

#Xloc keyword windows 10#

I’m using Microsoft 365 on a Windows 10 64-bit system. If you’d like to learn about XLOOKUP(), read How to use the newish XLOOKUP() dynamic array function in Excel. Unless I run into a specific reason to use one of the older lookup functions, I see no advantage to using them. I’m using XLOOKUP() going forward though. You could use VLOOKUP(), keeping a few things in mind: You must restructure the source data because the return value is to the left of the lookup value, and VLOOKUP() can’t handle that.

#Xloc keyword software#

SEE: Software Installation Policy (TechRepublic) Must-read Windows coverageĭefend your network with Microsoft outside-in security services In this article, I’ll show you how to use a wildcard in the XOOKUP() function’s criteria argument, or search string. This setup is helpful when you remember part of the search string, but not all of it. Instead of finding an exact or almost match, dropping in a wildcard allows you to work with a simpler search string.

Thanks to XLOOKUP() this task is easier than ever, and it even supports wildcards! In this article, I’ll show you how to use the asterisk wildcard (*) to create a more flexible lookup value. Lookup functions are great for finding values that match another value. Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. How to use wildcards with the XLOOKUP() function in Excel