# VLOOKUP with IF statement in Excel

In Excel, combine VLOOKUP with IF to get a result conditional on the value returned by VLOOKUP (yes/no, true/false, ...).

In this example, we'll check if a product is in stock based on its remaining amount:

Formula in G4

=

**IF**(**VLOOKUP**(F4,B$4:D$7,2,FALSE)>0,"Yes","No")*A*

*B*

*C*

*D*

*E*

*F*

*G*

*H*

*1*

*2*

*1st column*

*2nd column*

*3rd column*

*3*

*Product*

*Amount*

*Price*

*Product*

*In stock*

*4*

*Apple*

*24*

*$0.52*

*Yes*

*5*

*Banana*

*30*

*$0.24*

*👆 Try changing this value*

*6*

*Kiwi*

*0*

*$0.63*

*7*

*Lemon*

*41*

*$0.17*

*8*

*Show arrows*

Separator

## Procedure

- Build the VLOOKUP formula:
- Enter
**=VLOOKUP**in cell**G4**, where you want to see if a*Product*is in*Stock*or not. - Enter the Lookup value
**F4**, which contains the*Product*(Banana) you want to look for. - Enter the Search range
**B$4:D$7**, the range of data that contains all the*Product*and*Amount*values.

You can add the dollar sign ($) to fix the rows, so if you drag down the formula to check the stock of other products, the IF formula will always refer to the same rows. - Enter Column number
**2**, as the*Amount*column is the 2nd column of the Search range. - Enter
**FALSE**to look for an exact match.

- Enter
- Build the IF formula around the VLOOKUP formula:
- Enter
**IF(**between the = and VLOOKUP formula.

The formula looks like this:**=IF**(VLOOKUP(F4, B$4:D$7, 2, FALSE) - Enter
**>0**right after the VLOOKUP formula.

The formula looks like this:`=IF(VLOOKUP(F4, B$4:D$7, 2, FALSE)`

**>0**

The Test value of the IF formula says that the result of the VLOOKUP formula is greater than 0. - Enter
**"Yes"**, which defines if the Test value returns TRUE. - Enter
**"No"**, which defines if the Test value returns FALSE.

- Enter

## Result

The final formula is: `=IF(VLOOKUP(F4, B$4:D$7, 2, FALSE)>0, "Yes", "No")`

The IF formula finds that the *Amount* of Banana is greater than 0, so it returns TRUE. The value that appears in G4 is Yes.