Thread: Using reference table
View Single Post
 
Old 02-22-2013, 03:12 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
Attached Files
File Type: xlsx Iris damper reference.xlsx (21.0 KB, 11 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote