Help matching to multiple columns

Hi,

What I'm trying to do is return a True value if the following is true:

If the value in A2 of Table 2 is present in the A column of Table 1, then look in the corresponding row at the B column and C column in Table 1 to see if the letter 'Y' is present.

For example:

Excel.JPG

In the above, in the Value Y column, I should get:

True (because "1" is in the A column of Table 1, and the letter "Y" is in either the B column or C column of Table 1)
False (because "3" is in the A column of Table 1, but the letter "Y" is not in either the B column or C column of Table 1)
True (because "4" is in the A column of Table 1, and the letter "Y" is in either the B column or C column of Table 1)
False (because "7" is in the A column of Table 1, but the letter "Y" is not in either the B column or C column of Table 1)
True (because "9" is in the A column of Table 1, and the letter "Y" is in either the B column or C column of Table 1)

I think I need some IFs, LOOKUPs, ANDs, ORs and MATCHes, but I'm not sure and don;t know how to nest them.

Can anyone help.....?

Thanks

Solved with:

=OR(VLOOKUP(A2,'Table 1'!A:C,2,FALSE)="Y",VLOOKUP(A2,'Table 1'!A:C,3,FALSE)="Y")