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.
- ISBN10 161547997X
- ISBN13 9781615479979
- Publish Date 1 October 2013
- Publish Status Active
- Out of Print 1 April 2021
- Publish Country US
- Imprint Holy Macro! Books
- Format Paperback
- Pages 2
- Language English