Login & Start Learning!

or

VIDEO PLAYLIST

Testimonials

Patricia Henry

“During my last semester of college, I only knew a little bit of Excel and was in the job hunt for my post grad life. I purchased the student packet from Excel Tutor and learned may more than I ever thought possible about Excel. I am so excited to put all my new Excel knowledge on my resume.”

Patricia H.
David Phillips

“ I’ve been working in the insurance industry for a few years now and have been trying to get my fellow colleagues to understand Excel and perform at a more efficient rate. I found this site and after completing the courses myself, I now have my entire department completing these courses! ”

David P.
Phil Banks

“My boss told me that I needed to find a way to be “more efficient and effective” for my daily tasks. That’s when I went hunting for an online Excel course. Excel Tutor was the answer! I learned so many tricks and I even received a promotion in my job last week due to what I learned from this website.”

Phil B.

Lookup: VLOOKUP 2 Variables with Match

  • Description
  • Discussion
This video addresses the issue of the column number changing in your Vlookup formula. Sometimes, you want to pull data from a different column and are forced to go into your Vlookup formula and change the column number – not fun. The Match function allows you to dynamically change the column number by referencing a specific input cell. So now, if you want a different column of data, you can just specify in an input cell and the formula will update for you.

Support Files:

Lookup-Blank.xlsx Lookup-Complete.xlsx

Leave a comment

(Your email address will not be published.)

Rate this Video:

Avatar

Members Also Watched

  • Introduction (2m 4s)

  • Task 5: 6 – 10 (3m 36s)

  • Task 5: 1 – 5 (2m 54s)

Loading...