How to use VLOOKUP with VBA and automate calculations.
Details: http://www.exceltrainingvideos.com/vlookup-excel-vba/
For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V
If you are from India you can get this book here: http://amzn.to/2jzJGqU