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.
| ISBN: | 9781615479979 |
| Publication date: | 1st October 2013 |
| Author: | Bill Jelen |
| Publisher: | Holy Macro! Books |
| Format: | Pamphlet |
| Pagination: | 2 pages |
| Genres: |
Spreadsheet software |