Forum Discussion

Melissa21218's avatar
Melissa21218
Copper Contributor
Oct 27, 2022

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 the formula =large(S76:s146,1) to find which item sold the most and return that value to J143. How do I return the corresponding cell from column Q to I143?

 

Thank you in advance for your response.

Formulas and Functions

3 Replies

  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Oct 27, 2022

    Melissa21218 

    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))
    • Melissa21218's avatar
      Melissa21218
      Copper Contributor
      Oct 28, 2022
      That is exactly what I needed. Thank you so much, this has been plaguing me for days!

Resources