kylefoley76
Well-known Member
- Joined
- Mar 1, 2010
- Messages
- 1,553
I'm trying to go down column a, look for a certain word, let's say 'excel', then return the value in the cell four cells to the right.
My best guest was
=offset(search("excel",a:a),0,4)
But the search function and the find function really aren't built for that.
My best guest was
=offset(search("excel",a:a),0,4)
But the search function and the find function really aren't built for that.