CODEWITHSUNDEEP
google-sheetslookup
Robin33
Robin33

Reputation: 55

Get the top value of a column - Google Sheets

Imagine a table like this:

1$ 2$ 3$ Water Snickers Sandwich Chewing Gums M&Ms Iced Tea

In a different place I'd like to get the "price" of a "product". (Refering to the "product" and returning the "price")

So far, I tried lookup, index - match and a few more things, but none of those have worked for me. :/

If someone knows how to do this, that'd be very helpful!!

Upvotes: 0

Views: 35

Answers (1)

basic
basic

Reputation: 11968

You can use INDEX/MAX/ COLUMN functions:

=INDEX($A$1:$C$1;;MAX((F2=$A$2:$C$3)*COLUMN($A$2:$C$3)))

enter image description here

Upvotes: 2

Related Questions