This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: column to the left? Step 1 figure out the row we want. Lets find the density for viscosity 2.38 Use the MATCH function to find a row in a range Step 2: Use the row value we found in 1 to get the value function to find a value for a row and column It is a good idea to use absolute addresses for the lookup table. For instance, try auto filling the formula in B2 Tip: Try using a names range instead of a cell reference (Formulas > Name Manager menus)...
View Full Document
- Spring '10
- Relational Database, Expression, Tuple, Row