Hello JululianI solved my issues, but there is still one problem that my column C, the age equal or less than 24, that I did not solve i need your
=INDEX($C$7:$G$27, MATCH($L$9, $B$7:$B$27, 0), MATCH(1, (VALUE(MID($C$4:$G$4, 12, 2)) <= $M$9) * ($M$9 <= IF(ISNUMBER(VALUE(RIGHT($C$4:$G$4, 2))), VALUE(RIGHT($C$4:$G$4, 2)), 0)), 0))
Thank you for your support I appreciate your help so much many ThanksHello Jululian
It is good to see you again. You wanted to find the weight based on criteria such as height (155 cm) and age (between points), for example, 0 to 24, 25 to 29, etc.
Don't worry! I have developed a complex formula to fulfil your goal. However, I had to modify the heading a bit. I have demonstrated the idea in your given file.
SOLUTION Overview:
Complex Formula (Using INDEX, MATCH, VALUE, MID, RIGHT, IF and ISNUMBER):
I hope you have found the formula you were looking for. I have attached the solution workbook; good luck.
Regards
Lutfor Rahman Shimanto
ExcelDemy