Welcome Guest.

1Answers

Find the value greater than or equal to F4 in C2~C30, and return the number in the output C column that is greater than the D column corresponding to the F4 number in G4.

Asked by: Roberts 154 views IT August 6, 2019

Problem Description: How to enter the formula in G4 to achieve such a requirement: find the greater than or equal to F4 in C2~C30, and return the first number in the output C column that is greater than the D column corresponding to the F4 number in G4

1 Answers

  1. +7Votes  

    This can be done:

    G4:

    =INDIRECT("D"&MIN(IF($C$2:$C$30>=F4,ROW($C$2 :$C$30),4^8)))

    Pull down and copy.

    Answer: After the formula is edited, you must press Ctrl+Shift+Enter to confirm! !

    Daniel Patel- August 6, 2019 |