YTL Excel

Опубликовано: 09 Сентябрь 2008
на канале: excelisfun

26,701

Download Excel Files:
Start File: https://people.highline.edu/mgirvin/Y...
Finished File https://people.highline.edu/mgirvin/Y...
Full Page With All File Links: http://people.highline.edu/mgirvin/ex...

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