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 tagged 2010
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/
-
Authors
Copyright & Affliation Information
NOTE: I am in no way affiliated, sponsored, or compensated for these post(s) from any third party. These posts are my opinion(s) and anything I link to is at my sole discretion for the benefit of my readers, not for financial gain.
Unless explicitly stated, all works on this site are licensed under
WorkYourBest by Paul D. Wood is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Based on a work at www.WorkYourBest.com
Header & design image(s) provided by Vectorportal.com (CC BY 2.0) via flickr
Paul D. Wood
