Formula for returning value in adjacent cells

[Melissa21218]

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.

[#2]

@Melissa21218 

=INDEX(Q76:Q146,MATCH(LARGE(S76:S146,1),S76:S146,0))

This formula works in my sheet.

[#3]

@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))

[#4]

That is exactly what I needed. Thank you so much, this has been plaguing me for days!