XLOOKUP is the function you need when want to search for values by row. It allows you to select your desired range of data across multiple columns in order to ...