Forum Discussion
Solved
Formula Help, Please!
The above is an example of data in which I would like to have a combination of functions that will return a value from row 1 depending on two inputs (B12 and C13). The formula would look through row 7 (Matching the 5 located in B12) for the first number greater than 20 (Referencing C13). This would result in finding 20.5 in D7. It would then return the corresponding data of row 1 from that same column (Final answer: 1100). Any assistance would be greatly appreciated!
Anthony,
try this:
=AGGREGATE(15,6,C1:G1/(INDEX(C4:G9,MATCH(B12,B4:B9,0),0)>C13),1)
1 Reply
Anthony,
try this:
=AGGREGATE(15,6,C1:G1/(INDEX(C4:G9,MATCH(B12,B4:B9,0),0)>C13),1)