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:
<tbody>
</tbody>
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:
Range1 | Range2 | Return value |
Adam | Zoe | Adam |
Betty | Xenia | |
Chris | Adam | |
Danny | ||
Eva | ||
... |
<tbody>
</tbody>
Assumption: Item exists and there is only one. Therefore the formula doesn't have to take into account other situations.
Thanks for help.