There are about a million different reasons why VLookup has been replaced by Index/Match and now XLookup. Can we please get an updated activity that utilizes XLookup instead? Some of the major benefits are:
- The lookup column can become a table reference, making it much more robust to table structure changes
- Lookup reference can be anywhere in the table, not limited to left hand column
Thanks