Learn how to perform Excel multiple column lookups with ease using XLOOKUP, FILTER, SUMPRODUCT, and Boolean logic techniques.
Reference: The cell or range of cells or range of cells for which you want to return the column number ... Excel spreadsheet can have 16,384 columns in total. The data goes from up and down.