The IF function and the VLOOKUP function are widely used while working in Excel. The combination of these functions can find out specific values with certain conditions from the dataset. Here, we will discuss **7 **ideal examples to use IF statement with VLOOKUP for multiple conditions Range in Excel.

**Table of Contents**Expand

## 7 Ideal Examples of Excel IF Statement with VLOOKUP for Multiple Conditions Range

We can do some marvelous tasks using the combination of **IF **and **VLOOKUP **functions. In this section, we will discuss **7 **ideal examples of using **IF **function with **VLOOKUP **function for multiple conditions range.

### 1. Use IF Statement with VLOOKUP to Get Yes/No Result

Yes/No results for the presence of any specific value in the dataset can be checked using **IF **and **VLOOKUP **functions. Let’s discuss the example stepwise.

- Firstly, write the following formula in
**Cell F5**.

`=IF(VLOOKUP(F4,$B$5:$C$9,2,FALSE)=0,"No","Yes")`

- Consecutively, press
**Enter**. - As a result, we will see the yes/no result for the presence of
**Apple**(as we inserted**Apple**in**Cell F4**) in our stock.

**VLOOKUP**function searches for the value of

**Cell F4**in range

**$B$5:$C$9**and gives the value of

**column 2**of the range. The

**IF**function checks whether the value from the

**VLOOKUP**function is

**0**or not and gives the respective

**Yes/No**result.

**Read More: **How to Use IF Statement with Yes or No in Excel

### 2. Compare VLOOKUP Result with Another Cell Using IF Statement

In a bit similar way to example **1**, we can modify the formula a bit to compare the result with the maximum value in the dataset. Let’s jump to the stepwise procedures.

- Firstly, find the maximum value of column
**Quantity (Kg)**in**Cell F4**using the following formula.

`=MAX(C5:C9)`

- Now, we will compare any other quantity in the dataset with the maximum quantity.
- For that purpose, use the following formula in
**Cell F6**.

`=IF(VLOOKUP(F5,$B$5:$C$9,2)=F4,"Yes","No")`

**VLOOKUP**function searches for the value of

**Cell F5**in range

**$B$5:$C$9**and gives the value of

**column 2**of the range. The

**IF**function checks whether the value from the

**VLOOKUP**function is equal to the maximum value (

**Cell F4**) or not and gives the respective

**Yes/No**result.

**Read More: **How to Check If Cell Contains One of Several Values in Excel

### 3. Ignore Error from VLOOKUP and IF Statement Applying ISNA Function

In this example, we have some fruit names in **Product **and **Lookup List **columns. We will check if the fruit in the **Product **column is present in the **Lookup List**. If the **Lookup List **doesn’t have the fruit the **VLOOKUP **function will give error, we can ignore the error using** the ISNA function**. Follow the given steps for that.

- Firstly, use the following formula in
**Cell C5**.

`=IF(ISNA(VLOOKUP(B5,$E$5:$E$7,1,FALSE)),"No","Yes")`

**VLOOKUP**function doesn’t find the value it will give an error. The

**ISNA**function alternates the error with a

**True**value and vice-versa.

### 4. Perform Different Calculations on VLOOKUP and IF Statement Result

Now, we will compare the value from the **VLOOKUP **function with a specific value and if it is greater than or equal to that value, the result will be a discounted value. Otherwise, the formula will return the value from **VLOOKUP**. Follow the steps.

- Just write the following formula in
**Cell F5**and press**Enter**.

`=IF(VLOOKUP(F4,$B$5:$C$9,2,FALSE)>=100,VLOOKUP(F4,$B$5:$C$9,2,FALSE)*70%,VLOOKUP(F4,$B$5:$C$9,2,FALSE))`

**VLOOKUP**function searches for the value of

**Cell F4**in range

**$B$5:$C$9**and gives the value of

**column 2**of the range. The

**IF**function checks whether the value from the

**VLOOKUP**function is greater than or equal to

**100**or not and multiplies the value from the

**VLOOKUP**with

**70%**as

**True**value and shows the original value as

**False**value.

**Read More: **How to Use IF Statement with Not Equal To Operator in Excel

### 5. Get Data from Table Based on Another Cell Using VLOOKUP and IF Statement

In this example, we have **2 **columns **Shop 1 **and **Shop 2**. Based on the value in **Cells F4 **and** G5** we will find the respective **Price **of fruit. Follow the steps given below.

- Primarily, apply the following formula in
**Cell G6**and press**Enter**.

`=IF($F$4="Shop 1",VLOOKUP(G5,B5:D9,2,FALSE),VLOOKUP(G5,B5:D9,3,FALSE))`

**IF**function checks whether the value in

**Cell F4**is

**Shop 1**or not and gives true value

**VLOOKUP(G5,B5:D9,2,FALSE)**where the

**VLOOKUP**searches value of

**Cell G5**in range

**B5:D9**and gives value from column

**2**of that range. For the

**False**value of the

**IF**function the

**VLOOKUP**gives value from column

**3**.

### 6. Apply VLOOKUP for Multiple Conditions Range with IF Statement for Logical Test

Now, we will check if the result from the **VLOOKUP **function is equal to a specific text. Follow the given steps for that.

- Just use the following formula in
**Cell G5**.

`=IF(VLOOKUP(G4,$B$5:$D$9,2,FALSE)="Available","In Stock","Not in Stock")`

- Then, press
**Enter**.

**VLOOKUP**function searches the value of

**Cell G4**in the range

**$B$5:$D$9**and gives the value from column

**2**of that range. The

**IF**function checks if the output from

**VLOOKUP**is equal to text

**“Available”**and gives

**True**value

**“In Stock”**and

**False**value

**“Not in Stock”**.

**Read More: **How to Prepare IF Statement Contains Multiple Words in Excel

### 7. Insert VLOOKUP and IF Statement for Multiple Dates with AND Condition in Excel

Additionally, we can apply **VLOOKUP** for dates. So, learn the steps of this example to apply **VLOOKUP** for multiple dates with **IF** statement using **AND **condition in **Excel**.

- Firstly, write the following formula in
**Cell G4**.

`=VLOOKUP(F4,IF((C5:C9>=F5)*(C5:C9<=F6),B5:D9,""),3,FALSE)`

- Then, press
**Enter**.

**IF**function compares each cell of the range

**C5:C9**with

**F5**and

**F6**cell values. Subsequently, it returns the range

**B5:D8**as the logical test is true. Finally, the

**VLOOKUP**function seeks the

**F4**cell value (

**Grape**) in the range

**B5:D9**and returns the value in the 3rd column (

**George**).

**Read More: **How to Use IF Function with OR and AND Statement in Excel

## An Alternative to VLOOKUP with IF Statement in Excel

We can also use a combination of the **INDEX **and **MATCH **functions instead of **VLOOKUP **with **IF **function. Let’s follow the steps given below for this example.

- Simply, write the following formula in
**Cell F5**.

`=IF(ISNA(INDEX(C5:C9,MATCH(F4,$B$5:$B$9,0))),"Not found",INDEX(C5:C9,MATCH(F4,$B$5:$B$9,0)))`

- Then, press
**Enter**.

**MATCH**function searches for the value of

**Cell F4**in range

**$B$5:$B$9**and gives the row number. The

**INDEX**function takes the row number as an argument and gives the value from range

**C5:C9**. The

**ISNA**function checks for error in

**(INDEX(C5:C9, MATCH(F4, $B$5:$B$9, 0))**. If error remains, the function returns

**True**and vice-versa. This

**True/False**value acts as a condition for the

**IF**function and gives output

**“Not found”**for

**True**and

**INDEX(C5:C9, MATCH(F4, $B$5:$B$9, 0))**for

**False**.

**Download Practice Workbook**

You can download the practice workbook from here.

## Conclusion

In this article, we have discussed the examples of Excel IF Statement with VLOOKUP for Multiple Conditions Range. Hope you will be able to use these functions easily. Please leave comments if you have any suggestions.