1. In AO1:AT22, I have a grid of reference data.
--The data in these cells are calculated and reference values in other places in the worksheet.
2. In W1:Z5, I have my work area.
---The value in INCR is a static value that I type in.
---The values in COST, PRICE, and TICKS cells should be populated from the reference table above.
Problem:
What I would like to do is when I type a target value in the "Incr" column in my work area, it will automatically do a lookup in the reference table to exactly match the Incr value and then automatically fill in the corresponding COST, PRICE, and TICKS cells for that row. So I want the value I input in "Incr" to drive the lookup for the columns to the right.
Any help or suggestions would be greatly appreciated. Thank you for taking a look.
--The data in these cells are calculated and reference values in other places in the worksheet.
Step | Incr | Cost | Price | Ticks | Ratio |
0.10% | 0.10% | $0.81 | $1.13 | 113 | 0.01 |
0.20% | $0.81 | $2.26 | 226 | 0.02 | |
0.30% | $0.81 | $3.38 | 338 | 0.03 | |
0.40% | $0.81 | $4.51 | 451 | 0.04 | |
0.50% | $0.81 | $5.64 | 564 | 0.06 | |
0.60% | $0.81 | $6.77 | 677 | 0.07 | |
0.70% | $0.82 | $7.89 | 789 | 0.08 | |
0.80% | $0.82 | $9.02 | 902 | 0.09 | |
0.90% | $0.82 | $10.15 | 1015 | 0.10 | |
1.00% | $0.82 | $11.28 | 1128 | 0.11 | |
1.10% | $0.82 | $12.41 | 1241 | 0.12 | |
1.20% | $0.82 | $13.53 | 1353 | 0.13 | |
1.30% | $0.82 | $14.66 | 1466 | 0.14 | |
1.40% | $0.82 | $15.79 | 1579 | 0.16 | |
1.50% | $0.82 | $16.92 | 1692 | 0.17 | |
1.60% | $0.82 | $18.04 | 1804 | 0.18 | |
1.70% | $0.82 | $19.17 | 1917 | 0.19 | |
1.80% | $0.82 | $20.30 | 2030 | 0.20 | |
1.90% | $0.83 | $21.43 | 2143 | 0.21 | |
2.00% | $0.83 | $22.56 | 2256 | 0.22 |
2. In W1:Z5, I have my work area.
---The value in INCR is a static value that I type in.
---The values in COST, PRICE, and TICKS cells should be populated from the reference table above.
Incr | Cost | Price | Ticks |
2.00% | $0.83 | $22.56 | 2256 |
1.80% | $0.82 | $19.17 | 1917 |
1.10% | $0.82 | $16.92 | 1692 |
Problem:
What I would like to do is when I type a target value in the "Incr" column in my work area, it will automatically do a lookup in the reference table to exactly match the Incr value and then automatically fill in the corresponding COST, PRICE, and TICKS cells for that row. So I want the value I input in "Incr" to drive the lookup for the columns to the right.
Any help or suggestions would be greatly appreciated. Thank you for taking a look.