Video 00129 Tax Lookup_Alternative Solutions @MySpreadsheetLab
Video 00129 Tax Lookup_Alternative Solutions  @MySpreadsheetLab
Uploaded April 2015 | Updated September 2026, 2 hours ago
Get this Excel file here: http://1drv.ms/1bYwrTa
Alternative Solutions: (1) vlookup, (2) array.
We need to determine the tax amount based on two categories.

1) 0:00 Vlookup Solution
2) 2:10 Array Solution

Cheers,
Kevin Lehrbass
https:twitter.com/kevinlehrbass
http:myspreadsheetlab.com
Video 00129 Tax Lookup_Alternative SolutionsVideo 00016 VLOOKUP introductionVideo 00088 Proper Design = easy formula00147 Conditionally Add Checkboxes using VBAVideo 00128 Tax LookupVideo 00064 Customized and Sorted Data Validation List_Step 1Video 00033 Solution_identify rows if any in same group meet condition_V200176 Normalize & Pivot Taco Orders00182 Partial Match POWER QUERYVideo 00110 Low Tech Dynamic List00156 One complex formula or Helper formulasVideo 00044 Array Formulas_Example2_EXACT LEFT_functions
Kevin Lehrbass |

Video 00129 Tax Lookup_Alternative Solutions

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER