JMP Import: "XLookup" equation in Excel file
Great,in Excel 365 there is a new "XLookup/XVerweis" *) function
https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 But JMP doesn't seem to understand it (yet). Same at your site? *) In contrast to the old VLookup/Sverweis, for XLookup the column with the return values can now also be in front of the search values.No re-shuffling of columns anymore