Excel Forum
Similar Content
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...
FILTER() Function Excel - Power Lookup for the Future
Tutorial: The new FILTER() function for Excel 365 allows you to do amazing things with a single sim...
Excel Macro that Searches Entire Workbook and Returns All Matches
Macro: This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workboo...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




YTL Excel #119: Amazing Lookup Solution!


See how to use the INDIRECT and SUBSTITUTE functions to create an amazing Lookup solution using the Space Operator.

See the Space operator that solves the two-way lookup problem and see the INDIRECT and SUBSTITUTE functions and the Name Keyboard trick Ctrl + Shift + F3.

YTL Excel #119: Amazing Lookup Solution!
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
MrExcel's Learn Excel #965 - Two-Way Lookup
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH





Got a Question? Ask it Here in the Forum.