Get an index of a column with a cell of a certain word

hi @MGMKLML

Check this post
Get row and column index of cell with specific value

Thanks
Ashwin.S