On sheet 2 I have the index to the list of codes with their full text translations but I have many more codes in the index than appear in the list on sheet one. I need to insert a column that will allow me to filter out the useless codes.

On sheet 2 the codes at located in column A

I am looking for a formula I can put into sheet two cell b2 searching for the code listed in a2 that will return a "Yes" value if the code appears in the list on sheet 1 and a "No" value if it doesnt. Ideally it would be possible for me to then copy down the formula to the cells below so that I can then apply the filter to that column and remove the codes I dont need.

Any help with this is much appreciated!!

Thanks very much,

Harry