Since there is no functionality within XLOOKUP to return values by row, the TRANSPOSE function can be used. However there is currently no parameter within XLOOKUP that allows results to be returned by rows! The TRANSPOSE function This is accomplished when you add more than one column to your Return_array. This can come in handy when you are looking to return more than one value! This allows us to reduce the number of times that we need to use the XLOOKUP function we don’t have to do a separate formula for every line! Multiple Matching XLOOKUP RefresherĪs a quick reminder, unlike VLOOKUP and INDEX / MATCH, the XLOOKUP function is able to return multiple columns.
If we want to have them appear by row, we have to use the XLOOKUP / TRANSPOSE combination.īy using this multiple function combination, we can return results by row – not just by column. However when these values are returned, they show in multiple columns. With XLOOKUP, it is now possible to return multiple values from a single function.
0 kommentar(er)
