+ Reply to Thread
Results 1 to 5 of 5

A video about combining VLOOKUP and COLUMN

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    8

    A video about combining VLOOKUP and COLUMN

    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!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: A video about combining VLOOKUP and COLUMN

    It's a good video, as far as the quality of the screen capture. Well spoken, and you give good instructions. I would watch them in the future.

    But as far as the actual solution to the problem, I prefer to use Index/Match.
    In B2 of the first sheet, filled down and right to C3
    =INDEX(Sheet2!B$1:B$5,MATCH($A2,Sheet2!$A$1:$A$5,0))

  3. #3
    Registered User
    Join Date
    10-12-2017
    Location
    Brazil
    MS-Off Ver
    2016
    Posts
    59

    Re: A video about combining VLOOKUP and COLUMN

    Excellent tip.
    Congratulations

  4. #4
    Registered User
    Join Date
    12-17-2014
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    8

    Re: A video about combining VLOOKUP and COLUMN

    Quote Originally Posted by Jonmo1 View Post
    It's a good video, as far as the quality of the screen capture. Well spoken, and you give good instructions. I would watch them in the future.

    But as far as the actual solution to the problem, I prefer to use Index/Match.
    In B2 of the first sheet, filled down and right to C3
    =INDEX(Sheet2!B$1:B$5,MATCH($A2,Sheet2!$A$1:$A$5,0))
    Thank you! I wanted to keep things very simple in this video, but this technique could be good for a future video.

    Quote Originally Posted by gfranco View Post
    Excellent tip.
    Congratulations
    Thanks! And thanks for commenting on the video too, that will help me get some views.
    Last edited by RossSharma; 10-14-2017 at 11:27 PM.

  5. #5
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    1,167

    Re: A video about combining VLOOKUP and COLUMN

    As a person who works with a lot of ppl who need things spelled out as intuitively as possible and who's attention one has for a very limited amount of time this looks like a good approach.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1