All posts tagged 2010

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
- The greatest wisdom not applied to action & behavior is meaningless data. 4 days ago
- Someone tell me I should go out & socialize in spite of my physical pain. #maximizemyvacationtime 1 week ago
- It's the 2nd mouse to reach the trap that gets the cheese. - Do you always need news/info before anyone else? #informationoverload 1 week ago
- Feeling sorry for yourself is the same as publicly acknowledging that you are willfully incapable of controlling your own actions anymore. 2 weeks ago
- disappointed w/ @netflix it appears that you have reduced your streaming movies AND made it harder to browse. acct termination eminent #fail 3 weeks ago
Writer’s Guild
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

Follow

Follow “WorkYourBest.com”

Powered by WordPress.com