Using reference table

[BritBiker2]

Using the reference sheet, how do I set up the iris damper test sheet to automatically fill in the correct k factor when the manufacturer, type and size are filled out?

[macropod]

Hi BritBiker,

It's not clear how, with only the manufacturer, type and size, the correct k factor can be chosen. It appears the correct k factor is also a function of the damper setting. Accordingly, all four values (manufacturer, type ,size and damper setting) would have to be input. With those four inputs, the correct k factor for row 15 will be returned by the following as an array formula:
=OFFSET('reference sheet'!$A$1,MATCH($C15&$D15&$E15,'reference sheet'!$A$1:$A$40&'reference sheet'!$B$1:$B$40&'reference sheet'!$C$1:$C$40,0)-1,MATCH($F15,'reference sheet'!$A$2:$S$2,0)-1)
Array formulae are input with Ctrl-Shift-Enter. See attached.

[BritBiker2]

Thank you that has helped alot. I do have one minor problem regarding the reference talbe which has happened before. I want to be able to have the entries scroll up. When I highlight the first two rows and click on freeze it actually freezes the table down to row 10. why is this and how do i get over it?

[macropod]

Scroll up/down/left/right to poition the screen how you want it to appear when you're at your preferred 'home position, then select the cell you want to scroll from and choose View>Freeze Panes>Freeze Panes.