Constructed the metrics template for the next fiscal year through the use of various vlookup functions to ensure that management had a clearer picture of staff volume (jobhero.com)
Must possess an intermediate to advance level of skill with MS Excel to include VLOOKUP, Pivot Tables, VBA). (glassdoor.com)
Speaking of vlookup, I'm going to assume it only works with references in the same document. (gigaom.com)