Yes or No Answer

Hello-

I am trying to write a formula that will look up a value in an array and return either a yes or no as to whether it exists in the array. I thought about using a vlookup with an if statement but I cannot get them to work. Any help is appreciated. Thank you.

ConneXionLost-
Thank you for your reply. Unfortunately it did not work.

I need a formula that will take a cell value from "tab 1", look in a list (array) of values on "tab 2", if the value IS in the list (array) on "tab 2", leave a "yes" and if the value IS NOT in the list (array) on "tab 2", leave a "no". Does this help describe what I need better. Your help is appreciated.

ConneXion's suggestion will work just fine.
You just have to input the list and value
=IF(COUNTIF(Your_Array,Your_Value),"Yes","No")

YourArray is your 'List on tab 2'
YourValue is the value you want to find in the list..

But since you haven't given specific information about exactly where your 'List' or your 'Value' is (sheet name, range like A1:A100, etc...)
Then we can't create a formula that is that specific, we have to leave it to you to input those specifics.