Produce "Y" if VLOOKUP value is found, produce "N" if it is not.

[RodneyW]

Currently this formula =VLOOKUP(E6,'Survey Home Improvement'!$E:$F,2,FALSE) produces one of two results. Either "Home Improvement" (if the words Home Improvement are found in the second position) or #N/A if the words Home Improvement are not found. How can I change this so that "Y" will appear if the value is found or "N" if it is not?

Thank you in advance

 

[etaf]

=IF(ISNA(VLOOKUP(E6,'Survey Home Improvement'!$E:$F,2,FALSE),"N","Y")

 

[RodneyW]

=IF(ISNA(VLOOKUP(E6,'Survey Home Improvement'!$E:$F,2,FALSE),"N","Y")

Thank you for the response. I've copy/pasted exactly and I get an error message: "You've entered too many arguments for this function..."

 

[etaf]

sorry meant to add another closing bracket
=IF(ISNA(VLOOKUP(E6,'Survey Home Improvement'!$E:$F,2,FALSE)),"N","Y")
forgot the ISNA() and vlookup()

ISNA(VLOOKUP(........))

 

[RodneyW]

sorry meant to add another closing bracket
=IF(ISNA(VLOOKUP(E6,'Survey Home Improvement'!$E:$F,2,FALSE)),"N","Y")
forgot the ISNA() and vlookup()

ISNA(VLOOKUP(........))

Worked perfectly! Thank you

 

[etaf]

you are welcome