VLOOKUP used in IF function logical test argument to determine whether an employee is exempt from a tax, and if not use second VLOOKUP to look in tax tables to lookup and calculate the tax.
http://www.youtube.com/watch?v=xVoDySK6nEM&hl=en
Showing posts with label Different. Show all posts
Showing posts with label Different. Show all posts
Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables
Subscribe to:
Posts (Atom)