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

"Vlookup and If" wrote:

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

"Sean Timmons" wrote:

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" wrote:

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