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

Download Excel File: https://ift.tt/2UK2Evz
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
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.