0
What I need is almost a procv. I have a cell with a word and I need to search for that word in a column in another spreadsheet. But in the cells in that column there are several words. For example, I want to search in column A in which row appears 'grape'.
COLUMN TO
banana mango grape
pear orange
watermelon apple
lemon guava
Thank you!
1
It works:
The numbers in column A shall be greater than or equal to their list in column D
The formula in the cell And takes the word you inserted in cell B2 and looks for in the row of column D, if you do not find the number 0, otherwise put the number of the column A row
=SE( ÉERRO( LOCALIZAR($B$2;C2;1)); 0; A2)
In cell E7 has the following formula:
=SOMA(E2:E6)
to return on which line the word was found
and I copy it to cell C2
Ready.
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
I couldn’t take it. But you can follow from there.
– Reginaldo Rigo
Thanks for the reply but I don’t think I could explain well what I need.
– Saulo M