Login & Start Learning!

or

VIDEO PLAYLIST

Testimonials

“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.

“ 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.

“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 Approximate

  • Description
  • Discussion
The Vlookup function is a powerful business function used on a daily basis. The last portion of the function allows you to choose “Approximate” or “Exact.” Here, we learn how the Approximate version can be used when our data is in a range. For example, we want to look up a price based on the order size. Excel is able to look at a pricing table and return the correct price by approximating where in the list the value would fall. This function is used for numerical data when we have ranges.

Support Files:

Lookup-Blank.xlsx Lookup-Complete.xlsx

Leave a comment

(Your email address will not be published.)

Rate this Video:

Members Also Watched

  • Introduction (2m 4s)

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

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

Loading...