searching a particular row of Table 2 in Table 1

[aks_p123]

Hello,

Please help me in resolving my issue. Given are 2 tables each having 3 columns of same data type. I want to search a particular row from table 2 in table 1 and in return , if a particular row is found in table 1 it should change the cell color to "yellow" for that row. Also it should create another table which should include only those rows from table 2 which are not found in table 1.

Attached is the file with data on which this can be implemented.

Thnx
AKshay

[dilipandey]

HI Akshay,

welcome to the forum.

You can use below formula in conditional formatting to highlight the rows in table 2 which are found in table1 :-

Please Login or Register  to view this content.

Also, created a pivot table

which should include only those rows from table 2 which are not found in table 1.

see attached:- exp - Copy.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[aks_p123]

Thank You Mr Dilip,
Understood your concept . However, in place of "found in table1" if i want to display the position (row no. ) in table 1 where data is located. What changes will I have to do?

thank you once again
Akshay

[dilipandey]

Okay.. use below formula:-

Please Login or Register  to view this content.

enter with key combination ctrl shift enter

Regards,
DILIPandey
<click on below * if this helps>