just a quick question , what is the best approach to the following
i have A1 aus A2 fra & A3 ger
now below in cells A8 to B12 i have
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
and in cells D8 to D12
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
In cells E8 to E12 i am looking at the best formula to return "y" if any of column B8:B12 match that of A1:A3
any suggestions? many thanks
i have A1 aus A2 fra & A3 ger
now below in cells A8 to B12 i have
scott | ukr |
john | aus |
paul | fra |
tim | pol |
phil | sco |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
and in cells D8 to D12
scott |
john |
paul |
tim |
phil |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
In cells E8 to E12 i am looking at the best formula to return "y" if any of column B8:B12 match that of A1:A3
any suggestions? many thanks