What I need is almost procv. I have a cell with one word and I need to search for that word in a column on another worksheet. But in the cells of this column there are several words. For example, I want to search in column A on which line 'grape' appears.
COLUMN A
banana grape sleeve
orange pear
watermelon apple
lemon guava
Thank you!
This works:
The numbers in column A must be greater than or equal to your list in column D
The formula in cell E takes the word you entered in cell b2 and searches in the row of column D, if it does not find it, put the number 0 otherwise it puts the number of the row of column A
=SE( ÉERRO( LOCALIZAR($B$2;C2;1)); 0; A2)
In cell E7 it has the following formula:
=SOMA(E2:E6)
to return on which line the word
and I copy to cell C2
Ready.