I am trying to find a formula that will look at two columns in one row and find that pair in different columns..
Basically I am looking for a formula that will generate the middle column. If "column A and Column B" pair matches "column D and column E", column C will return YES
Example :
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
Basically I am looking for a formula that will generate the middle column. If "column A and Column B" pair matches "column D and column E", column C will return YES
Example :
Title | Author | In stock? | Lib-title | Lib-author |
A | AA | Yes | C | CC |
B | BB | Yes | D | DD |
C | CC | Yes | E | EE |
D | DD | Yes | F | FF |
E | EE | Yes | H | HH |
F | FF | Yes | I | II |
G | GG | Yes | G | GG |
H | HH | Yes | A | AA |
I | II | Yes | B | BB |
K | KK | No | ||
L | LL | No | ||
M | MM | No |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>