Excel Magic Trick #114: GetPivotData ISERROR and IF function
Loading...
Loading...
2:41
Excel Magic Trick #115: Find 2nd Positive Numberby ExcelIsFun1,500 views- 10:22
Excel Magic Trick #113: Nested IF & Short Term Loansby ExcelIsFun6,597 views
- 3:21
Excel Magic Trick #116: Find Best Poker Gameby ExcelIsFun3,167 views
- 4:46
Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functionsby ExcelIsFun16,202 views
- 6:54
Consolidating Data from Multiple Excel Worksheets By Positionby DannyRocksExcels23,612 views
- 4:03
Understand GetPivotData - 1127 - Learn Excel from MrExcelby bjele1233,605 views
- 3:01
ISERRORby AuditExcel2,603 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun37,408 views
- 6:54
Excel Name Trick #5: Names for Pivot Tables & more...by ExcelIsFun16,474 views
- 3:12
Excel Magic Trick #14: Amazing Find & Go To Trick!by ExcelIsFun22,717 views
- 7:55
Excel Magic Trick #130: 3 Dimensional Database in Excelby ExcelIsFun24,006 views
- 3:54
Excel Magic Trick #120: ISNUMBER & SEARCH functionsby ExcelIsFun7,828 views
- 7:40
Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2by ExcelIsFun22,891 views
- 3:45
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCHby ExcelIsFun14,110 views
- 8:00
YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filterby ExcelIsFun9,219 views
- 6:03
Excel Magic Trick #151: DATEDIF function (between two dates)by ExcelIsFun21,280 views
- 6:27
Excel Magic Trick #168: Cross Tabulation For a Surveyby ExcelIsFun17,023 views
- 10:32
Excel Magic Trick #148: Dynamic List from Table #3by ExcelIsFun15,154 views
- 2:02
Excel Magic Trick 250 Pivot Table Unique List in Unique Listby ExcelIsFun3,377 views
- 7:52
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteriaby ExcelIsFun21,046 views
Hey ExcelIsFun, how can I bring up a table done previously under the name Tab1,when I search it by the year that it corresponds? e.g - 2010 corresponds to Tab1.Write 2010 into the cell in order to bring up the Tab1 into another cell.Hopeless so far. Please help!DOes it make sense?
PinjolliFundit 2 years ago
I don't know a good way. Try the Mr Excel Message Board:
mrexcel[dot]com/forum
ExcelIsFun 2 years ago
Great stuff, Really useful....Many Thanks........
tumbaktu80 2 years ago
Dear tumbaktu80,
I am glad that you liked it!
--excelisfun
ExcelIsFun 2 years ago