6/5/2023 0 Comments Web xloc atAs 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. 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. 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. How to connect an Apple wireless keyboard to Windows 10 Microsoft offers Windows 11 for HoloLens 2 Windows 11 update brings Bing Chat into the taskbar Microsoft PowerToys 0.69.0: A breakdown of the new Registry Preview app SEE: Software Installation Policy (TechRepublic) Must-read Windows coverage 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
0 Comments
Leave a Reply. |