How to Use the Offset Function to Modify a VLookup Function in Excel HD

Each month, I get multiple emails and phone calls from viewers about the VLOOKUP Function in Excel. The common complaint is, the field that they need to "look for a match in" is NOT the 1st - or Left-most - field in the Table (Array). So, in this tutorial, I demonstrate how to use the OFFSET() Function in Excel to point the Lookup Value to the "correct" column in a Named Range. I invite you to visit my new Online Shopping Website - http://shop.thecompanyrocks.com - to see the 6 new products that I have introduced recently! Danny Rocks www.thecompanyrocks.com