0

I have two columns (A and B) in a Google spreadsheet:

   A              B
Number      Description
   2            desc1
   5            desc2
   1            desc3
   3            desc4

How can I return the content of cell B that's next to the minimum number in column A?

(In this case it's desc3 since 1 is the minimum number in A.)

migrated from superuser.com Nov 24 '17 at 9:09

This question came from our site for computer enthusiasts and power users.

2

That is not very accurate example, but it should give you your result and workability.

=indirect("B"&ArrayFormula(sum((row(A2:A5)*(A2:A5=MIN(A2:A5))))))

Explanation: We will use =indirect approach formula.

--- "B" by this we will define what column will be returned --- & this is delimiter that will connect "B" letter of searched column with following returned number of "row"

then goes the ArrayFormula function

--- row(A2:A5)*(A2:A5=MIN(A2:A5) is the range of rows that will be searched for MIN(A2:A5) criteria to return us the needed "row".

Thus we have connected "B" + "3" and got =B3 cell value.

  • Works. But I replaced "B" with REGEXEXTRACT(ADDRESS(ROW(), COLUMN()), "[A-Z]+") to make it more general like mentioned here: stackoverflow.com/a/22129496/900394 – Alaa M. Nov 20 '17 at 12:05
  • glad to help, your note will be also a help to me ;) – user1448914 Nov 20 '17 at 13:55
0

Please try:

=index(B:B,match(min(A:A,A:A),A:A,0))

INDEX
MATCH
MIN

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.