# A video about combining VLOOKUP and COLUMN

1. ## A video about combining VLOOKUP and COLUMN

Hi everyone,

I posted a short video detailing how to use VLOOKUP with COLUMN:

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. ## 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. ## Re: A video about combining VLOOKUP and COLUMN

Excellent tip.
Congratulations

4. ## Re: A video about combining VLOOKUP and COLUMN

Originally Posted by Jonmo1
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.

Originally Posted by gfranco
Excellent tip.
Congratulations
Thanks! And thanks for commenting on the video too, that will help me get some views.

5. ## 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.

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

#### 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