Excel VLOOKUP Laminated Tip Card
Author | : Bill Jelen |
Publisher | : Holy Macro! Books |
Total Pages | : 0 |
Release | : 2013-10 |
ISBN-10 | : 161547997X |
ISBN-13 | : 9781615479979 |
Rating | : 4/5 (979 Downloads) |
Download or read book Excel VLOOKUP Laminated Tip Card written by Bill Jelen and published by Holy Macro! Books. This book was released on 2013-10 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.