Posts tagged ‘MATCH’
Dueling Excel – “Sort with a Formula”: Podcast #1308
Today Dueling Excel looks at RANK, VLOOKUP, COUNTIF, LARGE and more!
Where is the Last in Row?: Podcast #1254
Looking at the INDEX and MATCH Functions . . .
Continue Reading September 28, 2010 at 12:10 pm MrExcel East
January Not = January – 1162 – Learn Excel from MrExcel Podcast
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.
…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!
Duel: Portugal – 1139 – Learn Excel from MrExcel Podcast
A viewer from Portugal sends in a question about finding which row contains the match. Episode 1139 shows you a few ways to go!
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!
Duel: 2-Way Lookup – 1124 – Learn Excel from MrExcel Podcast
Mike & Bill take a look at various ways to do a 2-way lookup in this dueling Excel Episode 1124.
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!
Many VLOOKUP Columns – 1123 – Learn Excel from MrExcel Podcast
VLOOKUP week continues…. Today, you have to lookup an account number and return the results from four columns in the lookup table. Episode 1123 shows you four possible solutions.
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!
