Excel Magic Trick

Published: 08 February 2010
on channel: excelisfun

34,618

129

Download Files:
https://people.highline.edu/mgirvin/Y...

See how to use the INDIRECT, TEXT, SUBSTITUTE, Named Ranges, Create Name From Selection, and Space Operator to do a two way lookup when the named ranges contain dates. Then see a much better method using VLOOKUP and MATCH functions.
See this video:
Excel Name Trick #7: INDIRECT function, Names and LOOKUP

On this page of the site you can watch the video online Excel Magic Trick with a duration of hours minute second in good quality, which was uploaded by the user excelisfun 08 February 2010, share the link with friends and acquaintances, this video has already been watched 34,618 times on youtube and it was liked by 129 viewers. Enjoy your viewing!

4,436

120