I have a column of data in B from row 5 to 23 (see below). I want to accept user input in cell M25 and use that input to to select a MATCH row of data from my list below.
For example, if the user inputs $74, the row number is 3. (greater than 70, less than 80)
My column data is similar and listed below. The user would enter a value in M27 and the MATCH column would be calculated using the same assumptions.
For example, if the user inputs $1625, the MATCH column would be 5 (greater than 1500, less than 1750)
I'm new to INDEX and MATCH and even newer with trying to assign a value using user input. Thanks all.
ROW DATA in B
<colgroup><col></colgroup><tbody>
</tbody>
COLUMN DATA in row 4
<tbody>
</tbody>
For example, if the user inputs $74, the row number is 3. (greater than 70, less than 80)
My column data is similar and listed below. The user would enter a value in M27 and the MATCH column would be calculated using the same assumptions.
For example, if the user inputs $1625, the MATCH column would be 5 (greater than 1500, less than 1750)
I'm new to INDEX and MATCH and even newer with trying to assign a value using user input. Thanks all.
ROW DATA in B
< $60 |
$60 |
$70 |
$80 |
$90 |
$100 |
$110 |
$120 |
$130 |
$140 |
$150 |
$160 |
$170 |
$180 |
$190 |
$200 |
$210 |
$235 |
$260 |
<colgroup><col></colgroup><tbody>
</tbody>
COLUMN DATA in row 4
$500 | $750 | $1,000 | $1,250 | $1,500 | $1,750 | $2,000 | $2,250 | $2,500 | $2,750 | $3,000 | $3,250 | $3,500 |
<tbody>
</tbody>