Yes, you can use the VLOOKUP function in Excel to return a "yes" or "no" answer instead of a column return. Here's the proper syntax:

Here's what each part of the formula means:

1. lookup_value: The value you want to look up in the table.
2. table_array: The range of cells that contains the table you want to search.
3. col_index_num: The column number in the table that contains the value you want to return.
4. FALSE: This tells Excel to look for an exact match of the lookup_value in the table.

The IF function checks whether the VLOOKUP function returns an error (#N/A), which means the lookup_value was not found in the table. If there is an error, the formula returns "no". If there is no error, the formula returns "yes".

Make sure to replace "lookup_value", "table_array", and "col_index_num" with the appropriate values for your specific situation.