excel: finding row number 2

[firegambler]

hi folks,

would be great if you could help me out with this:

i have a column containing values like say:
*Total Gross Sales
*Allowances & Discounts
**Net Sales
***VARIABLE COSTS
****PROFIT CONTRIBUTION
****Organisation Expenses
****Other Income
****Other Expenses
****OPERATING PROFIT

what i would like to know:
is there a function that returns the row in which a certain value i look for is located in?
e.g.
searchRow("**Net Sales";A1:A9) <-- would return 3


thanks in advance





regards

 

[AnotherHiggins]

=match("**Net Sales",A:A,0)

will do it for you.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[bluedragon2]

=MATCH("**Net Sales",A1:A10)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[firegambler]

Thanks 4 your help guys!!

regards