You can check the template for how INDEX formula enables the search function within the worksheet using a textbox. Download template with full access (Password: jafarpp.in)
BMI Calculator
Calculate Your Body Mass Index. Body mass index (BMI) is a measure of body fat based on height and weight that applies to adult men and women. Enter your weight and height using standard or metric measures.