How to use the If and Vlookup functions together in Excel




About this tutorial:

Video duration: 7:35
In this video, I will teach you how to determine whether an individual made their sales goal, and if that is true, then lookup their commission rate using the Vlookup function to determine their sales commission total.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

19 thoughts on “How to use the If and Vlookup functions together in Excel

    Luis Pontes

    (October 11, 2018 - 3:03 am)

    Awesome video. Totally solved my problem.

    Gauudi

    (October 11, 2018 - 3:03 am)

    Excellent Video Steve!!

    Ella Building

    (October 11, 2018 - 3:03 am)

    Very useful for my work. Thanks for this 😊

    Hammad Godil

    (October 11, 2018 - 3:03 am)

    I have a scenario in which i have to search products in 4 sheets in a workbook, i can use 2 vlookups in same formula but it wont let me place the 3rd formula. what do i do alongwith when the product is not found it gives error message "Product not found" same like your video giving No Comm. pls help

    James R

    (October 11, 2018 - 3:03 am)

    Smooth guy……really smooth.

    misfit

    (October 11, 2018 - 3:03 am)

    Have you done any vids where you use if and vlookup to subtract one cell from another such as dr – cr as at the mo I have dr – cr = x and then I vlookup that into another schedule but it would be good if I could have everything in one formula.  I have just struggled to find anything in this area.

    Boonnak A.

    (October 11, 2018 - 3:03 am)

    Nice & clear explanation.

    Jeff Liang

    (October 11, 2018 - 3:03 am)

    a side note I want to share is that, you can do iferror(vlookup(xxxxx), " ") to remove the NA error message.

    Bojack Fishman

    (October 11, 2018 - 3:03 am)

    Great help!

    Carlos Diaz

    (October 11, 2018 - 3:03 am)

    I was wondering if you could help me with a formula.

    84g3ta2dq

    (October 11, 2018 - 3:03 am)

    what if you have repeating numbers i your sales or goals column. Will you be able to sill use the if or vlookup conditions. I'm asking because i have a similar situation as this video however, i have some repeating numbers, and sometimes when i use the look up function that I'm trying to get picked up, another number in my table picks up another number with similar number in one column but a different number in the other column

    Mike Bowen

    (October 11, 2018 - 3:03 am)

    Very useful information. Thank you very much for the tutorial.

    osmond brinson

    (October 11, 2018 - 3:03 am)

    Hi Steve would you be willing to assist me with a spreadsheet Im trying to put together. Having a hard time trying to figure out which function would do what Im trying to.

    Alex Rosén

    (October 11, 2018 - 3:03 am)

    Great explanation. Thanks!

    Stephanie Smith

    (October 11, 2018 - 3:03 am)

    Thank you for your great explanation, it really helped me to understand this concept!!

    Mohammad Thafer

    (October 11, 2018 - 3:03 am)

    thank you so much

    Prashant Kothari

    (October 11, 2018 - 3:03 am)

    i want to lookup for data of certain value say if value in certain cell is >15000 what to do

    Shehab El Refai

    (October 11, 2018 - 3:03 am)

    whats that "2" for in the equation? didnt really get that

Leave a Reply

Your email address will not be published. Required fields are marked *