IF Function & V Lookup

[rmc2015]

Hi

I have 2 list's of Data. I want to run a vlookup formula on one data sheet with another.

If the Data is contained in the 2nd table I want to return the narrative "in stock". If it is not included in the other table I want to run the narrative "not in stock".

What formula would I use?

 

[steve the fish]

Use something like:

=IF(COUNTIF(Sheet2!A:A,Sheet1!A1),"In Stock","Out of Stock")

 

[rmc2015]

Thank you - That's it completed - Many Thanks for your help