Formulation
New Member
- Joined
- Aug 26, 2016
- Messages
- 25
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?
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?