![]() VLOOKUP is probably the most commonly used, but it’s restricted by the table format – the lookup key has to be on the left-most column of the array of data that we are performing the lookup for. To tackle this problem, we can use either: lookup or INDEX/MATCH formula. Does this situation sound familiar? Link here to the Excel example if you want to follow along. Our task is to bring some data from one table to another. We have two Excel tables, one contains some basic customer information, and the other contains customer order information. UPDATED Nov 15 2020: included the optional argument if_not_found in the Python code. ![]() ![]() I’ll be sharing another post on the statistics of the articles posted during the 30-day challenge. This is the day 30 of my 30-day challenge! I did it! I find myself also learning a great deal during this journey. In fact, we can use the same technique to replicate any of VLOOKUP, HLOOKUP, XLOOKUP, or INDEX/MATCH in Python! So today we’ll replicate the xlookup formula in Python. Excel LOOKUP formulas are probably one of the most used formulas (at least for me).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |