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

	A	B	C (Does value exist in table arrays)
1	Bob	CL30N	Formula
2	Bob	VA21	Formula
3	Bob	VA23	Formula

<tbody>
</tbody>

Sheet2 below

	A	B (range/table array 1)	C (range/table array 2)
1	Bob	CL30N	R1
2	Bob	R5	R6
3	Bob	D3	VA23

<tbody>
</tbody>

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.