my_account
New Member
- Joined
- Mar 9, 2019
- Messages
- 1
Hi All,
I am trying to compare two tables of having varied rows and columns. I want to see if values in table 1 matches with data in table 2. I am using index and match formula. I am checking each cell in table 1 with table 2 data set.
However I am getting 'no match' everytime. Can anyone please provide right formula.
=IF(ISNA(INDEX(table2_data,MATCH(a2,table2_data,0))),"No Match",a2)
Table A - Sheet 1
<tbody>
</tbody>
Table B - Sheet 2 ( number of rows and columns could be different than table 1)
<tbody>
</tbody>
Required Output
<tbody>
</tbody>
I am trying to compare two tables of having varied rows and columns. I want to see if values in table 1 matches with data in table 2. I am using index and match formula. I am checking each cell in table 1 with table 2 data set.
However I am getting 'no match' everytime. Can anyone please provide right formula.
=IF(ISNA(INDEX(table2_data,MATCH(a2,table2_data,0))),"No Match",a2)
Table A - Sheet 1
a | 0 | 0 | 0 | 0 | ||||
b |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
c | Bond | Note | Bill | Bill | ||||
d | Street | Market | Market | Market | ||||
e | Private | Public | Govt | School |
<tbody>
</tbody>
Table B - Sheet 2 ( number of rows and columns could be different than table 1)
a | 0 | 0 | 0 | 0 | ||||
b |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
c | Bond_1 | Bond | Bill | Bill_2 | ||||
d | Street | Market | Market | Market | ||||
e | Private | Public | Govt_5 | School_9 |
<tbody>
</tbody>
Required Output
0 | 0 | 0 | 0 | ||
No Match |
<tbody> </tbody> |
<tbody> </tbody> | Jan 01, 1900 | ||
<tbody>
</tbody>