A simple MATCH formula is not working. In episode 1162, we wander through the Validation dialog, the Name Manager dialog, all trying to figure out why the MATCH formula is returning #N/A.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Today's dueling Excel podcast question is how to return the sum of all columns from a VLOOKUP. Mike and Bill show you various methods in episode 1161.
Riham asks if there is any way to arrange the sheet tabs in two rows. While there is not, episode 1160 shows various ways of dealing with the issue.
Using PowerPivot for Excel 2010 to mashup data on two different worksheets.
David asks how to use Text to Columns to grab the right-most two characters from a column. Episode 1158 shows you how.
Ed asks how to assign a list of weekdays to a name in Excel. Episode 1156 shows you how.
Take geographic data from Excel and plot it as a route in MapPoint. Episode 1154 shows you how.
Harold from Tulsa asked how to write a macro to simulate double-clicking the fill handle. Episode 1152 shows you how.
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!
