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 VLOOKUP. Show all posts
Showing posts with label VLOOKUP. Show all posts
Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function
See how to create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table, the VLOOKUP function and the labels in the lookup area automatically update. See how to create dynamic Named ranges using OFFSET for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup table. Defined Names Name Manager dialog box.
http://www.youtube.com/watch?v=oNPVNc8cze0&hl=en
http://www.youtube.com/watch?v=oNPVNc8cze0&hl=en
Subscribe to:
Posts (Atom)
