I have a non-fixed excel table. The number of rows and columns of the table can vary each time.
In the GYD column, I need to copy the cell where the cell containing the word “Tlm” and the TT column intersect. For example, if the GYD column is in column A, if the word “Tlm” appears in the 17th row of the GYD column and the TT column is the C column, then I want to copy C17. In the screenshot below, you can see the cell I want more clearly. I think someone in here may help me. Waiting your ideas:)