MATERIAL | TEMPERATURE | ALLOWABLE |
STEEL | 300 | 423 |
STEEL | 350 | 427 |
STEEL | 400 | 428 |
STEEL | 450 | 425 |
STEEL | 500 | 419 |
STEEL | 550 | 410 |
STEEL | 600 | 401 |
<tbody>
</tbody>
Hi all,
I have a table like this where I store my values. Also I have two textboxes inside a user form. One is for inputting the temperature value and other for outputing the allowable after forecasting for that particular temperature values.
- What I was doing in the worksheet was,
- using index match function to get the values ,lower and upper to the input value ,
- using vlookup to get corresponding allowable
- Store these 4 values in particular cells
- using forecast function to interpolate from these for values
Thanks in advance.