![]() ![]() TEXTJOIN by Sheetzoom: a good comparison between all Excel text combining functions. The CONCAT function by Spreadsheet Web: another short post showing the differences between the former formula CONCATENATE and the new.The CONCAT function by Excel Buddy: a simple article that goes straight to the essentials of syntax and basic examples.If you’re keen to learn the CONCAT formula, here are the best resources: ![]() ![]() It’s basically the same as the original, but it now allows you to take whole ranges of cells into account! (as well as saving you 5 keystrokes!). The next function is an improved version of the key formula CONCATENATE. *French equivalent = RECHERCHEX Excel formula #2: CONCAT XLOOKUP examples by Chandoo: here the famous blogger shows you how to can get the function in Excel and suggests that you download an example workbook to start using XLOOKUP.XLOOKUP explained by Excel Campus: this post details the pros and cons of the formula and also comes with a video explanation.XLOOKUP by How to Excel: a complete article about the formula including a video tutorial so you can start practicing.How to use the XLOOKUP function in Microsoft Excel by How to Geek: this post reviews the main benefits of the Excel feature and is a good introduction to understand it.If you’re interested in learning more, check out the articles below: If you’re an Excel afficionado, you won’t have missed last year’s XLOOKUP formula! It’s basically the replacement function for Excel LOOKUP and INDEX + MATCH functions.Īs of early 2020, XLOOKUP is still a beta feature available for Office365 subscribers who have signed up to be an Office Insider. BONUS: Top Excel formulas videos 2020 Excel formula #1: XLOOKUP ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |