79382178

Date: 2025-01-23 18:32:19
Score: 0.5
Natty:
Report link

This is the formula in I2 (dragdown) using the INDEX-MATCH functions
Add equal sign to comparisons if needed.

=INDEX(D$2:D$9,MATCH(1,(G2=A$2:A$9)*(H2>B$2:B$9)*(H2<C$2:C$9),0))

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: Black cat