Hi,
I have two ranges of cells. I would like to check if there is an item in both of those ranges and if so, to return the item.
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Range1[/TD]
[TD]Range2[/TD]
[TD]Return value[/TD]
[/TR]
[TR]
[TD]Adam
[/TD]
[TD]Zoe[/TD]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Betty[/TD]
[TD]Xenia[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Adam[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Danny[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eva[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Assumption: Item exists and there is only one. Therefore the formula doesn't have to take into account other situations.
Thanks for help.
I have two ranges of cells. I would like to check if there is an item in both of those ranges and if so, to return the item.
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Range1[/TD]
[TD]Range2[/TD]
[TD]Return value[/TD]
[/TR]
[TR]
[TD]Adam
[/TD]
[TD]Zoe[/TD]
[TD]Adam[/TD]
[/TR]
[TR]
[TD]Betty[/TD]
[TD]Xenia[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Adam[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Danny[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Eva[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Assumption: Item exists and there is only one. Therefore the formula doesn't have to take into account other situations.
Thanks for help.