If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

You can use command-line parameters to launch Microsoft Excel from the Run dialog box or by configuring the command and switches in a desktop shortcut.

This tutorial will explain how to find a value in an Excel column using the Find function in VBA.