3 ms·
> You can do this in Powerquery. Yeah, pretty sure that having to use an ETL layer before Excel qualifies as "It's literally impossible to do it in Excel". >
by iLoveOncall 4y ago
> You can do this in Powerquery.
Yeah, pretty sure that having to use an ETL layer before Excel qualifies as "It's literally impossible to do it in Excel".
> Use XLOOKUP.
It's only available after Excel 2019, and the behavior is different. There's also nothing that seems to indicate that it doesn't have the same issue with column types?