Skip to playerSkip to main content
Bill Jelen
  • 14 years ago
Shawn has to do a four-way lookup: Worksheet, Row, Set of Columns, Column within the Set. To get the correct LOOKUP result, Bill shows a method using INDEX and INDIRECT to solve the problem posed in Episode #1413. Learn Excel 2010 by Bill Jelen
Be the first to comment
Add your comment

Recommended

2:34
Up next
MrExcel's Learn Excel #976 - Default Comment
Bill Jelen
11 years ago
3:19
Learn Excel 2010 - "Date Next to a Yes" #1474
Bill Jelen
14 years ago
7:51
Dueling Excel - "Rank Ties by Weight" #1473
Bill Jelen
14 years ago
3:39
Learn Excel 2010 – “Wrap Cells and Resize" #1472
Bill Jelen
14 years ago
2:08
Learn Excel 2010 - "Random with No Repeats" #1471
Bill Jelen
14 years ago
6:30
Learn Excel - "Copy Total to Weeks Macro": #1470
Bill Jelen
14 years ago
2:22
Learn Excel - "Random Weeks Over 6 Months": #1469
Bill Jelen
14 years ago
2:58
Learn Excel - "Added Times Won't Calculate": #1468
Bill Jelen
14 years ago
1:01
Learn Excel - "Column B is now Column 2?": #1467
Bill Jelen
14 years ago
1:26
Learn Excel 2010 - "Embed a PDF in Excel": #1466
Bill Jelen
14 years ago
2:24
Learn Excel 2010 - "Remove Spaces with VBA": #1465
Bill Jelen
14 years ago
5:49
Dueling Excel - "Keep The Last Duplicate": #1464
Bill Jelen
14 years ago
2:02
Learn Excel - "Left 26, Even If Only 10": #1463
Bill Jelen
14 years ago
1:50
Learn Excel 2010 – “Word Count from Word”: #1462
Bill Jelen
14 years ago
6:24
Learn Excel "Pivot Table Defaults": Podcast #1461
Bill Jelen
14 years ago
4:00
Learn Excel - "Word Count from Sentences": #1460
Bill Jelen
14 years ago
9:09
Dueling Excel- "Pivot Table Totals on Left": #1459
Bill Jelen
14 years ago
2:29
Learn Excel - "Scroll In The Formula Bar": #1458
Bill Jelen
14 years ago
3:17
Learn Excel 2010 - "Excel Outside The Box": #1457
Bill Jelen
14 years ago
2:58
Learn Excel from MrExcel - "Pivot to Range": #1456
Bill Jelen
14 years ago
1:37
Learn Excel 2010 - "Drag Formula Reference": #1455
Bill Jelen
14 years ago
7:54
Dueling Excel - "The Top 70%": Podcast #1454
Bill Jelen
14 years ago
5:13
Learn Excel 2010 - "Clear If New Day": #1453
Bill Jelen
14 years ago
4:16
Learn Excel 2010 - "Shift Change?": Podcast #1452
Bill Jelen
14 years ago
3:21
Learn Excel 2011- “MAC xlautomatic”: Podcast #1451
Bill Jelen
14 years ago