|
|
#2
02-22-2013, 03:12 AM
|
||||
|
||||
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] 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode