Forum Discussion
Formula for returning value in adjacent cells
Hello, I'm looking for a formula that would return the text in a cell adjacent to a search result. For example: column Q has the list of the items sold, column S is the number of items sold. I use t...
Hello Melissa, two possibilities that solve your problem:
=XLOOKUP(MAX(S76:S146),Q76:Q146)
or
=INDEX(Q76:Q146,MATCH(MAX(S76:S146),S76:S146,FALSE))