Independent Publishers Group Logo

Sign up today...
for featured titles, special offers, bestsellers, and more, in your inbox!

Subscribe to receive special offers, monthly books suggestions, seasonal selections, and more!

Close
Excel VLOOKUP Laminated Tip Card
Excel VLOOKUP Laminated Tip Card

Excel VLOOKUP Laminated Tip Card

Master VLOOKUP from MrExcel

COMPUTERS

2 Pages, 8.5 x 11

Formats: Pamphlet

Pamphlet, $2.95 (US $2.95) (CA $2.95)

Publication Date: October 2013

ISBN 9781615479979

Rights: WOR

Holy Macro! Books (Oct 2013)

Sorry, this item is temporarily out of stock
 

Overview

Excel's VLOOKUP function is useful when merging two data sets and this handy laminated card has all the tips needed to perform it. The tip card first explains how and why VLOOKUP should be used and covers advanced VLOOKUP topics, such as summing all the matches, finding the last match, and finding a value to the left of the key field. Lookup variants, such as HLOOKUP, LOOKUP, INDEX, and MATCH are also included.

Author Biography

Bill Jelen is an Excel expert at www.mrexcel.com, a regular on TechTV Canada’s Call for Help, and a video podcaster who is regularly listed in the iTunes top 50. He is the author of Excel Gurus Gone Wild, Pivot Table Data Crunching, Slaying Excel Dragons, and 14 titles in the Excel for Professionals series. He has been named a Microsoft MVP for seven years and is a contributor to CFO Magazine and Strategic Finance Magazine. He lives in Akron, Ohio.