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

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

#### Excel Expert

(October 11, 2018 - 3:03 am)

#### 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