tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
I have a list of data in column A:
apple
orange
pear
I want to search for this string in the data:
and return 2 (because orange is the second value in the list).
I have tried:
as well as the Instr function but neither worked,
Is this even possible?
Thanks
apple
orange
pear
I want to search for this string in the data:
Code:
small oranges sold
and return 2 (because orange is the second value in the list).
I have tried:
Code:
Like "*orange*"
as well as the Instr function but neither worked,
Is this even possible?
Thanks