Blog About Stuff That's In Your Home | Appliances and Stuff

07 Nov 11 Excel Lookup Series #1: VLOOKUP Function 1st Example

See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from column 2 of lookup table. Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate. In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel. Excel Magic Trick 167p2 IF function formula: 12 Examples! Excel Magic Trick 167p1 IF function formula: 12 Examples!

Tags: Example, Excel, Function, Lookup, Series, VLOOKUP

10 Aug 11 Highline Excel Class 40: VLOOKUP 11 Unusual Examples

See these 11 VLOOKUP tricks: 1.VLOOKUP algorithm 2.VLOOKUP, Named Ranges, Exact Match, COLUMNS function& Data Validation List 3.Commission Calculation: VLOOKUP, Approximate match, 3 VLOOKUPS in one formula 4.VLOOKUP with TRIM function to remove spaces from first column of lookup table, add zero to convert text back to number 5.VLOOKUP with TRIM function to remove spaces from lookup value 6.VLOOKUP and Ampersand to create Product ID 7.VLOOKUP with Table on Different Sheet 8.VLOOKUP and MID function to extract part of text string for the lookup value 9.Partial Text VLOOKUP (Exact Match) with wildcards 10.Calculate Currency Exchange with VLOOKUP Into Currency Rate Web Query 11.VLOOKUP appears incorrect because of Formatting This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109
Video Rating: 4 / 5

Tags: Class, Examples, Excel, Highline, Unusual, VLOOKUP

16 Apr 11 Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets

See how use VLOOKUP when there are 3 tables on 3 different sheets. See how to use the VLOOKUP & INDIRECT functions as well as named cell ranges in a formula that can handle lookup in three 3 different tables. Also see an Excel Consolidation to accomplish the same task.

Tags: #231, Diff, Excel, Magic, Sheets, Tables, Trick, VLOOKUP