match and index not working

[my_account]

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

a	0	0	0	0
b	Jan 01, 1900 <tbody> </tbody>	Jan 01, 1900 <tbody> </tbody>	Jan 11, 1900 <tbody> </tbody>	Jan 01, 1900 <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	Jan 05, 1900 <tbody> </tbody>	Jan 01, 1900 <tbody> </tbody>	Jan 10, 1900 <tbody> </tbody>	Jan 11, 1900 <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	Jan 01, 1900 <tbody> </tbody>	Jan 11, 1900 <tbody> </tbody>	Jan 01, 1900

<tbody>
</tbody>

 

[tomanton]

why not to check if a2 in sheet 1 is equal to a2 in sheet2?