Self-Devpt. Nuggets™

Finally, my Excel Visual Basic Automation Tutorial Videos are back with audible audio!

For 2 weeks I battled audio recording problems in creating video tutorials. First it was that NO audio was recorded at all. Later, VERY low audio was picked up by the headset mic I was using.

My usual relentless approach to dealing with problems kept me going at it, until I found a way. So here’s Tutorial 05…!

The screenshot below shows the user interface I created to explain how I constructed the INDEX/MATCH formula used in the ExcelVB Automation Tutorial 04.

All my Excel Heaven Visual Basic Automation club members got a compressed zipped folder containing the video tutorial along with the MS Excel Tutorial Workbook in their emails.

Excerpts:

1. In-cell drop down menu for choosing “Item Name” from the table. I use it here to enable easy comparison of the behaviour of the functions in 2, 3, and 4.

2. The syntax for the INDEX function shown below the result it gives

3. The syntax for the MATCH function shown below the result it gives

4. The syntax for the INDEX/MATCH formula shown below the result it gives via combination of the INDEX and MATCH functions.

****Full explanation in the screenshot step-by-step video tutorial emailed to you, along with this workbook (click here to request a copy).****

Quick Tip: In Windows 7 and above, you can watch the video using the VLC player simply by double clicking on the FLV video file (the largest of 3 filed) that you will find AFTER you unzip the compressed zipped folder emailed to you.