Hi @avene,
Refer this post, Find cell with String Value and get no. of row, name of column - #8 by arivu96
Regards, Arivu