VLOOKUP To Get Complete Record: ROWS, COLUMNS or SEQUENCE Function? EMT 1532

In this video see how to use VLOOKUP to retrieve an entire record using three methods: 1) COLUMNS, 2) ROWS, 3) SEQUENCE.

1. (00:05) Introduction
2. (00:35) Do we show record horizontally, or vertically? Discussion of sequential numbers that represent the column numbers needed by the VLOOKUP Function.
3. (01:33) COLUMNS & VLOOKUP
4. (03:51) ROWS & VLOOKUP
5. (04:48) SEQUENCE & VLOOKUP (requires that you have Office 365)
6. (07:57) Summary

[ricardoob]

Hi, Mike. Thank you for your all amazing videos. Just one doubt about this one... With Columns or Rows functions, it is possible to fix the beginning and use them without knowing the last column (just drag)...Drag and delete the blank results... With Sequence, it seems we have to know the quantity of columns prior to writing it in the formula... Is it correct? Regards, Ricardo - Rio de Janeiro - Brazil.

[sl]

I have been looking for this answer for two days!!!! How to copy down rows without having to hard code them!!! Thank you so much for this vid!!! Will be watching it again and again!!!

[fernando]

You make it very understandable, thank you very much

[saven]

you are my savior. 2 days of watching videos and reading suggestions online. You are the only one who explained this well enough for me to understand. Thanks for video. subbing right here

[mergenman]

Only one word about your Chanel! The best!

[Fxingenieria]

Thank you for this amazing videos Mr. Mike Irvin !!

[lazaeb]

Awesome. Due to you my excel skills are now awesome

[richardhay]

SEQUENCE has many great uses and this is certainly one of them.

[lakeshed]

I subscribed with the speed of sound... Guy knows excel in and out

[LeilaGharani]

Thank you Mike for another wonderful video :)

[drsteele]

I think SEQUENCE is the better solution. I also notice that ROW, ROWS, COLUMN and COLUMNS are functions that do not report an error when they refer to the cell which they occupy. At 4:50
wouldn't this be simpler? =FILTER(dEmp[[First]:[StartSalary]], dEmp[ID]=B20)

[m.sz.]

VLOOKUP. Always from a new perspective. Thanks.

[shameemnassiree]

Being a QuickBook Accountant I need excel all the time. And videos are helping me a lot

[sevagbarsoumian]

Thanks Mike,
with SEQUENCE is awesome..!!!

[anandsharma]

Wow. ....vlookup and sequence. ...great you so much for all your videos...

[enriquedominguez]

Easy to understand and apply, Mike. Great explanation as always. Thank you.

[angelokimi]

Wow! this will totally solve the issue I face everyday in my reports!
Thanks a bunch!! 😊😊

[sanjeevsoni]

Amazing Use of Sequence and Column and Idea of using Table Header simplify and will create dynamic vlookup. Looking forward for the next video.

[sachinrv]

This is amazing Mike; Most people are still scared to integrate vlookup with rows or columns. Such kind of integration works like team where result of one function becomes input for the other. I however, many times prefer to integrate match with vlookup (using exact column lables); so even when the sequence of the column changes; the vlookup result is accurate because match brings out relative position of data in array. Thanks for upload :)

[richardhay]

During the time since I posted my original comment to this video I have been trying FILTER(CHOOSE) with this data set. I have worked through several examples and I believe I like FILTER(CHOOSE) the best for this type of setup. I hope you and your family have a Merry Christmas and a Happy New Year and I hope Santa brings the rest of us lots of new ExcelIsFun videos to watch during 2019! Thanks for all your Hard Work!! :)