Hi everyone,
I posted a short video detailing how to use VLOOKUP with COLUMN:
https://www.youtube.com/watch?v=xZjJleolWYI
This simple technique allows you to write VLOOKUPs that don't fail when you move the columns of the referenced table.
It also gives a short explanation of reference arguments vs. value arguments, and how references will automatically update when a range is moved.
I think it could help beginner and intermediate users to make their workbooks more robust, and also to understand certain core concepts a little better.
I'd love it if you could give me some feedback on this video because I'm thinking of making a series. Thanks!
Bookmarks