Using Vlookup and If functions simultaneously

[Vlookup and If]

Is it possible to use Vlookup and If functions together in one formula? If
so, please give an example.

 

[Sean Timmons]

Depends on the If you want!

If(I3="",VLOOKUP(J2,Sheet1!A:E,4,0),0)

Are you attempting to accomplish something that we can help with?

 

[Vlookup and If]

Is it possible to do the vlookup first and then based on what is in the cell
apply the if function?

 

[Sean Timmons]

Well, that would be =IF(VLOOKUP(J2,Sheet1!A:E,4,0)="X","TRUE","FALSE")