Tag Archives: College

Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a lookup for Pictures in Excel 2007 using: Data Validation Dropdown List INDEX and MATCH Functions Defined Names Excel 2007 Hint (from Joe): Insert Bitmap Image (Insert Ribbon Tab, Text group, Object) instead … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 19 Comments

Excel Magic Trick 906: Ctrl + Backspace: Keyboard To Jump To Active Cell In Worksheet or Formula

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Keyboard to jump to Active Cell is Ctrl + Backspace: 1. In A Formula 2. In The Worksheet Shmuel Oluwa at Facebook!!! Duration : 0:2:2 Technorati Tags: 2003, 2007, 2010, active, At, Backspace, cell, College, Community, Ctrl, … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , | 12 Comments

Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Excel 2003 0r 2007: See 4 methods to allow a person to enter “ID Number” OR “Name” (Lookup value is one OR another thing from two differenet columns in the database) and lookup the correct Record: 1. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 10 Comments

VLOOKUP function Beginner to Advanced 26 Examples (Excel VLOOKUP WEEK Video #1)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 25 Comments

Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. : VLOOKUP A Date and Pattern To Simplify Formula Duration : 0:2:31 Technorati Tags: 2003, 2007, 2010, AND, College, Community, Date, Dragon, excel, excelisfun, formula, Girvin, Highline, Mike, Pattern, simplify, Slaying, to, vlookup

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , | 4 Comments

Excel Magic Trick 873: VLOOKUP – Lookup that rounds to the nearest number (Increment Equal)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to: 1. See how to avoid the default VLOOKUP behavior and instead find a value in the first column of the lookup table that is closest to the lookup Value. 2. Because the increment between … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 8 Comments

Excel Magic Trick #245: Matching 2 Lists w IF & OR functions

Check to see if values in one list are in another list with the IF and OR functions in a simple array formula. See how to use the IF and OR functions in a simple array formula that shows WINNER … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , | 6 Comments

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to return all the numbers from a column that contains text and numbers. See an array formula that uses the functions: COUNT, IF, ROWS, INDEX, ISNUMBER, … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , | 15 Comments

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | 25 Comments

Excel Magic Trick 836: VLOOKUP Lookup Value Not Matching Value in 1st Column (4 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to deal with the situation where you can see that the lookup value is the same as a value in the first column of the lookup table, but it is not giving you a match: … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 11 Comments