Populate Table 1 based on values in Table 2

[Alan1981]

Hello,

I have a table I need to populate like below

Table 1

a b c d e f g
1
2
3
4
5
6
7
8
9
10


This table should be populated from the Table2 below.If the values match in table 2 I need to display as true or false value in table 1. The reason I need this is to create a vendor list for procurement.

Table 2

1 b
2 f
3 a
4 g
5 b
6 f
7 a
8 e
9 g
10 a

Any ideas how I should approach this?

thanks for your help

Alan

[tuph]

Assuming table 1 starts in column A row 1 and table 2 starts in column A row 15, in cell B1 put =VLOOKUP(A1,$A$15:$B$24,2,FALSE). Copy the formula down cells B2:B10.

[Alan1981]

Hello,

I may have explained the problem incorrectly.
Table 2 would have multiple valules

Table 2


a 1
c 2
a 3
g 4
b 5
c 1
a 7
e 8
g 1
a 10

A VLookup will not work in this occasion because it will default to the first value that it meets ignoring the rest.

[Alan1981]

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

[Mark@Work]

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.

[Alan1981]

Thanks,

Problem Solved