All posts tagged reference

Vertical Lookup Function [Excel 2007 & 2010]

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 [...]

Leave a Comment

by Paul D. Wood on August 3, 2011 • Permalink

Posted in Excel, Office Suite

Tagged 2007, 2010, excel, lookup, reference, spreadsheet

Posted by Paul D. Wood on August 3, 2011

http://workyourbest.com/2011/08/03/vertical-lookup-function-excel-2007-2010/

Find a Topic:

Search for:
Categories
Authors
- Paul D. Wood
Recent
Twitter Updates
- Formatting & Keyboard Shorcuts for Date & Time Data [Excel 2007] wp.me/p1sY1G-30 1 month ago
- Graduated Response to force web users to prove innocence in 10 days if accused(not convicted) of copyright infringement bit.ly/GXRonz 2 months ago
- How does @lifehacker not have a "Print" compatible page formatting button? #basicwebfeatures 2 months ago
- DoJ bit.ly/z0HkVn claims APPL $-fixing on e-books @caseyjohnston #antitrust 2 months ago
- If ure in the market for an iPad2, why not wait until 2/7 to see if APPL drops the $ due to iPad3. Also, an 8GB iPad2? bit.ly/yHLKJR 3 months ago
Writer’s Guild
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

Follow

Follow “WorkYourBest.com”

Powered by WordPress.com