One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will allow you to do something …