Lookup formula?

[MaggieLou]

Hi, I need a formula that finds rows that contain certain text ("n=") then applies a formula for rows below it, but only until the next "n=" row is encountered.
Worksheet is attached and explained within.

Many thanks for any help!

[bebo021999]

In M20
If you want to refer to nearest "n=" in column F, the get corresponding value in column K:
LOOKUP(2,1/($F$17:F20="n="),$K$17:K20)

So, condition statement should be added:

=IF(OR(LOOKUP(2,1/($F$17:F20="n="),$K$17:K20)<100,LOOKUP(2,1/($F$17:F20="n="),$L$17:L20)<100),"",Your-formula)

[MaggieLou]

thanks so much for your help. I feel terrible for not acknowledging earlier but this is much appreciated!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[MaggieLou]

Thanks. I marked as solved and added reputation.
I just tried to post another question and I am blocked for some reason. Is "securinet" legit?
thanks.

[bebo021999]

I just tried to post another question and I am blocked for some reason. Is "securinet" legit?
thanks.

One of popular reason is " < " or " > ". Try insert 1 space before and after the " < > " to avoid sucuri wall.

[alansidman]

You probably have some sequence of letters that Securi believes is a SQL statement. Use of certain words generally will trip up this issue.

[MaggieLou]

Thanks to both!! I was able to submit my post now.