Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?
Loading...
Loading...
10,110
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (22)
-
Awesome. I like the VBA solution.
Although... the name Reverse Index would have been closer to what the Formula does.
-
Phew! lost me there. Great to see two giants of Xcel/VBA together in one clip.
Great job guys!
I used to be OK with basic and could dimension arrays,nest loops, call subs on variables etc but VBA is really challenging me now. Don't know yet what commands will follow each other and getting lots compile & syntax probs.
-
I made two newer videos that show more robust formulas that can handle all duplicate situations:
Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations
Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers
Loading...
- 8:05Mr Excel & excelisfun Trick 96: LOOKUP Function...by ExcelIsFun568 views
- 6:35Excel Magic Trick 862: Count Numbers In Column,...by ExcelIsFun1,651 views
- 7:31Mr Excel & Excelisfun Trick 95: Conditionally F...by ExcelIsFun1,314 views
- 10:23Excel Magic Trick 861: Conditional Format 50 Co...by ExcelIsFun1,604 views
- 8:47Mr Excel & excelisfun Trick 38: Weekly Report F...by ExcelIsFun8,910 views
- 5:08Stacked & Clustered - 1091 - Learn Excel Podcastby bjele1238,909 views
- 9:05Excel Magic Trick 571: VLOOKUP To Create Form f...by ExcelIsFun10,892 views
- 6:28Excel Magic Trick 729: VLOOKUP When Multiple Lo...by ExcelIsFun8,409 views
- 7:24Mr Excel & excelisfun Trick 12: Sort Numbers Wi...by ExcelIsFun5,213 views
- 4:19Create an Excel UserForm, Part 2 of 3by contextures144,532 views
- 9:33Excel Magic Trick 478: Reverse Two Way Lookup F...by ExcelIsFun3,227 views
- 2:39Excel Dashboard Example - How to Create Powerfu...by camoesjo205,471 views
- 10:10Mr Excel & excelisfun Trick 20: Summarize Surve...by ExcelIsFun6,888 views
- 16:36Highline Excel Class 44: Basics of INDEX & MATC...by ExcelIsFun15,123 views
hi Mike,
sorry for the very late reply, thanks for the tip. tricks no.478 and 479 is the way to go. Love it.
ronguiller2 2 months ago
@ronguiller2 , cool! I am glad thatthose help!
ExcelIsFun 2 months ago
hi Mike,
awesome video, I never thought it was possible to do a reverse lookup for column headers and row headers, however I've noticed something. for truck no.4 you've extracted 8:00 AM on both cells instead of an 8:00 am and an 11:00 am. could it be that both data coming from the same column had somehow confused the formula?
ronguiller2 4 months ago
@ronguiller2 , see this video that has a more robust formula:
Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations
or
Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers
ExcelIsFun 4 months ago
I think Bills way wins!!!!!!!
asdee01 1 year ago
Cool!
ExcelIsFun 1 year ago