Formula to return row number of a word in a list with duplicates
<pre><code>Shoes       20  
Pants       10  
Tshirts     15  
Socks       5  
Hats  
Shoes  
</code></pre>

<p>I am looking for an excel formula that will return the row number that the word "shoes" is in. <code>MATCH</code> will work but this returns <strong>1</strong> when I need it to return <strong>6</strong> based off the fact that it is the first "shoes" that has a blank cell next to it. Is this possible? I have tried in vain to use <code>IF</code> and <code>ISBLANK</code> but to no avail.</p>

<p>Any help greatly appreciated, Thanks</p>