[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]MATERIAL[/TD]
[TD]TEMPERATURE[/TD]
[TD]ALLOWABLE[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]300[/TD]
[TD]423[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]350[/TD]
[TD]427[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]400[/TD]
[TD]428[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]450[/TD]
[TD]425[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]500[/TD]
[TD]419[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]550[/TD]
[TD]410[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]600[/TD]
[TD]401[/TD]
[/TR]
</tbody>[/TABLE]
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.
Thanks in advance.
<tbody>[TR]
[TD]MATERIAL[/TD]
[TD]TEMPERATURE[/TD]
[TD]ALLOWABLE[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]300[/TD]
[TD]423[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]350[/TD]
[TD]427[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]400[/TD]
[TD]428[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]450[/TD]
[TD]425[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]500[/TD]
[TD]419[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]550[/TD]
[TD]410[/TD]
[/TR]
[TR]
[TD]STEEL[/TD]
[TD]600[/TD]
[TD]401[/TD]
[/TR]
</tbody>[/TABLE]
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.