Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables

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

Hot Game !!!

Deixe o seu comentario