Greetings,
I want the function to return the largest number in the row by cross-referencing a selected variable (column). My thought was a simple xlookup, however, I continue to get value errors. The formula I thought would work was =XLOOKUP(Cell, column array, LARGE(table array,1)). I have tried different variations but still can?t seem to find one that works. Any help is much appreciated.
Juan
Bookmarks