Forum Discussion
Michael_Gorske
Feb 06, 2023Copper Contributor
searching for a word in columb and pulling up the first referenced cell
Good day, Normally I can excel and figure this out, but I found myself in a situation that nothing seems to take or work. I need help. I am trying to create a tracker at work that will refer...
OliverScheurich
Feb 06, 2023Gold Contributor
=INDEX($G$4:$G$8003,MATCH("*"&A112&"*",$G$4:$G$8003,0))An alternative could be INDEX and MATCH.