Ask Your Question

Select values from cells according to contents of other cells

asked 2019-02-13 19:28:04 +0100

galaxian gravatar image

I have data in several long columns. For each row, in column Z I want to have appear the numbers from columns P,Q,R according to the maximum value in columns A,B,C.

For example for each row, if cell B contains a bigger number than either A or C, then I want the number from cell Q to appear in cell Z. If on the other hand cell C is bigger than either A or B, then I want the number from cell R to be in cell Z. And so on.

How can I do this please?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-13 20:59:11 +0100

updated 2019-02-13 21:30:22 +0100

Hello, @galaxian

You can use formula =INDEX(P1:R1;0;MATCH(MAX(A1:C1);A1:C1;0))

--- Edit ---

Please note that if there are two (or more) equal largest values in cells A1:C1, then index of the first matched value will be returned.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-13 19:28:04 +0100

Seen: 27 times

Last updated: Feb 13