Does value exist in 2 or more table arrays (VLOOKUP)

[Formulation]

I want find out if B2 in Sheet1 exists in column B or C in Sheet2.
If B2 exists in either column B or C in Sheet2, I would like to display Yes or True.
If B2 does not exist column B or C in Sheet2, I would like to display No or False.

For example:
Sheet1
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C (Does value exist in table arrays)[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Bob[/TD]
[TD]CL30N[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Bob[/TD]
[TD]VA21[/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Bob[/TD]
[TD]VA23[/TD]
[TD]Formula[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2 below[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B (range/table array 1)[/TD]
[TD]C (range/table array 2)[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Bob[/TD]
[TD]CL30N[/TD]
[TD]R1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Bob[/TD]
[TD]R5[/TD]
[TD]R6[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Bob[/TD]
[TD]D3[/TD]
[TD]VA23[/TD]
[/TR]
</tbody>[/TABLE]

Looking up to see if a value exists in one column on Sheet2 works fine... I'm just having trouble figuring out how to see if the value exists in multiple columns.
- I was using formula =VLOOKUP(B2,'Sheet2'!$B:$B,1, FALSE) in C1 of Sheet1. Which works for one column... how can I get it to work with multiple columns?

 

[DRSteele]

Smashing arrays together seems more logical and easier to conceptualise. Try these two array formulas in C3 and D3. Invoke each correctly and copy down.

Book1
	A	B	C	D
1	Sheet1
2	A	B	C (Does value exist in table arrays)	D (Does value exist in table arrays)
3	Bob	CL30N	Yes	Yes
4	Bob	VA21	No	No
5	Bob	VA23	Yes	Yes
6
7	Sheet2 below
8	A	B (range/table array 1)	C (range/table array 2)
9	Bob	CL30N	R1
10	Bob	R5	R6
11	Bob	D3	VA23
Sheet31

Cell Formulas
Range	Formula
C3	{=IF(MAX((A3&B3=$A$9:$A$11&$B$9:$B$11)+(A3&B3=$A$9:$A$11&$C$9:$C$11)),"Yes","No")}
D3	{=IF(MAX(--(A3&B3=$A$9:$A$11&$B$9:$C$11)),"Yes","No")}
Press CTRL+SHIFT+ENTER to enter array formulas.