Buy Dideo Subscription
10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More Download File for Lookup Formulas: Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/WAAT-LookupFormulas-Start&Finished-08-26-2016-Accounting%20Seminar.xlsx Pdf notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/WAAT-LookupFormulas-08-26-2016-Accounting%20Seminar.pdf Event: WAAT: Washington Association of Accounting & Tax Preparation Excel Seminar August 26, 2016 files In this video see: 1. (01:23) Data Validation List. VLOOKUP, Exact Match. IF & ISBLANK functions. Goal: Create Invoice. 2. (13:01) How to use VLOOKUP Exact Match, LEFT, MID and SEARCH to do a "Partial Text Lookup. Learn about Data Mismatch. Goal: Lookup Product Price. 3. (21:32) VLOOKUP with Approximate Match Lookup. Cell Reference for Column Index Number. Goal: Get Rating and Commission. 4. (26:49) VLOOKUP with Approximate Match and MATCH functions with Exact Match. MATCH for Column Index Number. Goal: Retrieve Rating & Commission. 5. (31:15) Use MATCH to Compare Two Lists. Goal: Is an item in List 1 also in List 2? 6. (34:50) INDEX and MATCH functions to do a "Lookup Left". Goal: Given a flight range, lookup boomerang name in first column. 7. (37:29) INDEX and MATCH to find Vendor for Low Bid. INDEX array argument is a row. Goal: lookup vendor name for lowest bid. 8. (40:04) How to use VLOOKUP & CHOOSE to do a lookup to multiple tables. Goal: Lookup Commission rate from Multiple Lookup Tables. 9. (46:46) Multiple VLOOKUP functions. Goal: Calculate taxes from complex tax table. 10. (53:31) SUMPRODUCT & LOOKUP functions with Approximate Match. Goal: "Lookup Adding" to get total revenue
