As a follow-up to [Episode #1252],  “Once you’ve used the HLOOKUP to return the last value in the row, can you find the date associated with that entry?” Yes, you can!  Today, in Episode #1254, Bill shows us how to locate the last value in a row of data and return that value to our designated cell using the INDEX and MATCH Functions.

"Learn Excel 97-2007 from MrExcel" by Bill Jelen…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

For all of your Microsoft Excel needs visit – Your One Stop for Excel Tips and Solutions.