join two cells on certain cell row values

So I have one set of data as such

TFS{6x315} and T{6x10} example:

,

the 6 rows are: directory file name, polarisation, degrees, sample name and raw data.

the T cell is the sample and TFS is the background data.

My goal is to write a code which takes the values of date, polarisation and degree from T and matches it to the equivilent data in TFS. I have seen similar solutions with arrays of data but not with cells could anyone help me with a simple solution or point me in the right direction?

Answer 1

[Sajid Afaque]

try converting the cells to table format.

then you can explore inner join feature of tables to perform your task