'Vlookup'
37 Metacafe Videos
-
09:49
VLOOKUP In Excel 2007 06-Feb-08
Rated 4.00 5,323 Views 1 Comments
Several examples of using the VLOOKUP function in Excel 2007
From formail More Entertainment, How To
-
07:49
Microsoft Excel Vlookup Function to Assign Discounts Based on Difference Between Two Dates 17-Feb-09
Rated 3.33 542 Views 0 Comments
Using Vlookup, how do you apply a certain discount on fees based on how early an applicant pays. For example: offer a 10% discount if an...
From Webiano More How To, Science & Tech
-
08:23
Duel: Unsorted VLOOKUP - 1144 - Learn Excel from MrExcel Podcast 17-Nov-09
Rated 3.30 92 Views 0 Comments
Martin from Sweden sends in a question about doing a range VLOOKUP where the lookup table is not sorted. Mike and Bill duel it out in tod...
From MrExcel More How To, Science & Tech
-
01:29
VLookup 29-Jan-09
Rated 2.94 394 Views 0 Comments
Excel VLookup
-
04:17
Many VLOOKUP Columns - 1123 - Learn Excel from MrExcel Podcast 19-Oct-09
Rated 2.90 90 Views 0 Comments
VLOOKUP week continues.... Today, you have to lookup an account number and return the results from four columns in the lookup table. Epis...
From MrExcel More How To, Science & Tech
-
03:34
Opening Balance VLOOKUP - 1115 - Learn Excel from MrExcel Podcast 05-Oct-09
Rated 2.84 84 Views 0 Comments
Brett from Australia asks how to format a date to include the words Opening Balance so that he can do a VLOOKUP into a report. The format...
From MrExcel More How To, Science & Tech
-
03:13
Convert Percentages to Letter Grades With Excel VLookup 05-Jun-09
Rated 4.76 74 Views 0 Comments
Convert percentages to letter grades with a VLookup formula in Excel. For written instructions see http://www.contextures.com/xlFunctions...
From ddalgleish More Science & Tech
-
02:49
MrExcel's Learn Excel #1002 - Multiple VLOOKUP 29-Apr-09
Rated 3.48 922 Views 0 Comments
Peter asks how to return multiple records from a VLOOKUP. In Episode 1002, I will show you how to use an Advanced Filter to achieve this...
-
02:48
VLOOKUP 101 - 1120 - Learn Excel from MrExcel Podcast 12-Oct-09
Rated 2.93 125 Views 0 Comments
VLOOKUP is my favorite function in Excel. In Episode 1120, we will take a look at the basics of VLOOKUP. This blog is the video podcast...
From MrExcel More How To, Science & Tech
-
08:17
Dueling: VLOOKUP Left - 1060 - Learn Excel Podcast 20-Jul-09
Rated 4.93 163 Views 0 Comments
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...
-
02:45
MrExcel's Learn Excel #949 - Grouping Ages 12-Feb-09
Rated 3.98 58 Views 0 Comments
Steve asks how to group records into age ranges. In Episode 949, I show how to use the range version of VLOOKUP to solve this problem. T...
-
03:07
ALL #N/A's - 1122 - Learn Excel from MrExcel Podcast 14-Oct-09
Rated 3.21 107 Views 0 Comments
What happens when you enter the perfect VLOOKUP formula and everything returns #N/A? Episode 1122 shows you some of the sneaky reasons wh...
From MrExcel More How To, Science & Tech
-
03:48
MrExcel's Learn Excel #927 - Pivot Compare 13-Jan-09
Rated 3.97 613 Views 0 Comments
Match two worksheets using a pivot table. We continue on this week with Jim's question about matching two worksheets with a common column...
-
04:59
Find Last Match - 1073 - Learn Excel from MrExcel Podcast 11-Aug-09
Rated 4.88 34 Views 0 Comments
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...
-
03:19
Embedding Lookup - 1135 - Learn Excel from MrExcel Podcast 02-Nov-09
Rated 4.33 14 Views 0 Comments
Nick asks how to do a pretty lengthy bonus calculation. It might be too complex for the Excel 2003 nested IF limit, so I decided to use t...
Looking For Affiliate Videos...
