#1
|
|||
|
|||
Using reference table
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? |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks
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?
|
#4
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why does Word separate table and reference endnotes by allowing text to go in between | newby2013 | Word Tables | 2 | 12-31-2012 03:45 PM |
Cross-reference problem | Marineboy | Word | 2 | 08-05-2011 03:37 AM |
2 figures cross reference | mmdmov | Word | 0 | 05-05-2010 09:12 AM |
How do I reference a merged cell in a multi column & row table in MS Word ('03')? | jihanemo | Word Tables | 0 | 03-18-2009 08:33 AM |
How do I return from a cross reference? | smoggymark | Word | 0 | 10-21-2008 07:45 PM |