![]() ![]() In the introductory article, we showed you how to use the JOIN clause in a simple SQL query to get data from two related tables. Check out our article here to learn more about XLOOKUP. It adds a couple of cool new features and addresses some limitations in VLOOKUP. ![]() TIP : Microsoft introduced XLOOKUP in late 2019 as the replacement for VLOOKUP. I can add a similar formula in cell E4 and then copy it down to populate the table: VLOOKUP(B4,$G$4:$J$13,3,FALSE)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |