Data to match

[dinkss]

Hi there,

I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I match it? I mean - how to assign data from bottle types to material? Is there any formula like vlookup or anything else? I have no idea how to start Can you help me please?

I just want to get YES / NO to show in the rows with material number which would indicate what bottle type is used for which product.

 

[dinkss]

No. You are merely checking for the existence within a series if single column lists. Countif and Match are the goto functions.

Oh ok, see I don't know when or where to use VLOOKUP.
Could you write a formula with MATCH function? Would it look the same as the one you gave me already?