Populate Table 1 based on values in Table 2

Hello,

I have attached a sample file to show my problem.

I need to populate table 1 with a true or false based on the values in table 2.I have tried using a VLookup but it only retrieves the first value or first occurence.

Thanks

It's amazing how often this little gem appears in this forum.

Assume your table 2 is in A2:B11

Your table 1 has a to g in cells D1 to J1 and 1 to 10 in C2 to C11.
Set D2 : =NOT(NOT(SUMPRODUCT(-($A2=$C2),-(D$1=$B2))))
Replicate through the rest of the table.

This uses the fact that TRUE = 1 and FALSE = 0 ...

Mark.

Thanks,

Problem Solved