+ Reply to Thread
Results 1 to 6 of 6

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
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    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.

  6. #6
    Registered User
    Join Date
    08-17-2021
    Location
    india
    MS-Off Ver
    office 2019
    Posts
    3

    Re: A video about combining VLOOKUP and COLUMN

    thanks for tips

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup - Adding values togheter (video explanation)
    By Niklaslarsson in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-06-2017, 10:54 AM
  2. help me to review this video for basic Vlookup. Thank
    By basicIT in forum Excel General
    Replies: 1
    Last Post: 12-19-2016, 04:13 PM
  3. Replies: 1
    Last Post: 07-16-2016, 12:26 PM
  4. VLOOKUP - #N/A - (video inside)
    By domgilberto in forum Excel General
    Replies: 9
    Last Post: 06-12-2015, 11:28 AM
  5. Open a video file in a specific point of the video
    By anbe45 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2013, 04:03 PM

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