Vlookup Mastery: Learn Vlookup Hlookup and Index Match In-Depth

by Vijay Kumar

Vlookup, Hlookup and Index Match


This book is specifically written for the lookups function in Excel. This book covers advanced concepts in Vlookup, Hlookup and Index Match functions.
If you know these three functions in depth, then all the database capabilities of the Excel can be utilized in its fullest capability.

Each chapter contains example files for you to practice along while you read this book. By implementing the techniques specified in this book you will save a huge amount of time.

All the example files are explained in detail with simple data.
I can definitely say this book will address so many problems you face with the Lookup functions.


The main portions covered in this book are given below.

What is Vlookup?
Wildcards in Vlookup
Other Vlookup uses
Hlookup
Handling Errors
Vlookup Combinations
Index Match
Common Problems and Errors in Lookups

63 pages, Kindle Edition

Published January 25, 2018

Reviews

[Amod Mhaskar · Rating 5 out of 5]

Good sessions with examples

Good one and the examples given for practice help a lot. Keep doing the good work
Will look forward for many more helpful books from the author