Goal: To create a formula that will read an input value and match it within a range of data [in a table], returning said matched row’s specified output column. Procedure: Create your reference table Create your input table Enter “=VLOOKUP(“ > select your lookup value (aka the value you want to cross-reference with the data [...]
All posts in category Excel
Vertical Lookup Function [Excel 2007 & 2010]
Posted by Paul D. Wood on August 3, 2011
http://workyourbest.com/2011/08/03/vertical-lookup-function-excel-2007-2010/
Define Variable Names to Spreadsheet Cells [Excel 2007 & 2010]
Goal: To define an individual cell or array of cells with a variable name. Procedure: Formulas > Defined Names (group) > Define Name (button) A New Name dialog box will appear, input the variable name, scope, and referring cells. Comment is optional. If you select the same range of cells you previously named, you should [...]
Posted by Paul D. Wood on June 16, 2011
http://workyourbest.com/2011/06/16/define-variable-names-to-spreadsheet-cells-excel-2007-2010/
-
Authors
Copyright Information
Unless explicitly stated, all works on this site are licensed under
Paul D. Wood's Résumé by Paul D. Wood is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Based on a work at www.PaulDuncanWood.com.
Header & design image(s) provided by Vectorportal.com (CC BY 2.0) via flickr
Paul D. Wood
