VLOOKUP is a function in Excel that enables people to use Excel like a database, joining data on different worksheets. VLOOKUP Awesome Quick is an ehnanced eBook designed to get the reader up to speed with the VLOOKUP function in Excel. The book starts with the basics of "e;Explain a VLOOKUP in plain English"e;, "e;How to Enter Your First VLOOKUP"e;, how to troubleshoot VLOOKUP when you get all #N/A or a few #N/A errors. Steps to make VLOOKUP easier. Real-life applicatons of VLOOKUP. The book moves on to advanced topics like moving beyond VLOOKUP to using INDEX and MATCH, Two-way VLOOKUP, Finding the last match, finding the last item in a column, and more. The book includes 7 videos and 5 audio clips.
| ISBN: | 9781615474097 |
| Publication date: | 1st February 2012 |
| Author: | Jelen, Bill |
| Publisher: | Holy Macro! Books |
| Format: | Digital Product (Other) |