If condition on a vlookup cell

[Geek491]

I need help...

Using =VLOOKUP(B2,Sheet1!A1:I95,4) which results in a "1" in the cell

I want to add a condition that if cell is "1" then "Yes" if not then "No"

I tried just a normal =VLOOKUP(B2,Sheet1!A1:I95,4)+IF(1,"Yes","NO") and I get an error.

Any help?

 

[thomazzs]

And if you specify the function as follows: IF((VLOOKUP(B2,Sheet1!A1:I95,4))=1;"YES";"NO") ?

 

[Jonmo1]

Welcome to the board.

Try
=IF(VLOOKUP(B2,Sheet1!A1:I95,4)=1,"Yes","No")

 

[LBinGA]

Try this: =IF(VLOOKUP(B2,Sheet1!A1:I95,4,FALSE)=1,"Yes","No")

LBinGA