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!
Duel: Matching Prospects – 1109 – Learn Excel from MrExcel Podcast
BackIn2Shape at YouTube has two worksheets; one of customers, and one of prospects. If a prospect is on the customer list, he would like to delete it. Episode 1109 show 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!
Find Last Match – 1073 – Learn Excel from MrExcel Podcast
Sarah from the cattle farm in the UK writes in again with an insanely difficult question. Do a VLOOKUP, but find the last previous entry that matches the vehicle. Episode 1073 shows you a formula from Excel Gurus Gone Wild to solve this problem.
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!
Dueling: VLOOKUP Left – 1060 – Learn Excel from MrExcel Podcast
In today’s dueling Excel podcast, how to do a VLOOKUP left. In Episode 1060 Bill and Mike show differing methods, from INDEX and MATCH to LOOKUP.
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!
