Hi

I have a a range of cell lets say db5:do5. I need to check which is the
first value in this range whcih is between 80% to 120% of ae5. In cell
dp5 i need excel to return the column heading (range db4:db5) of the
cell which meets the above said condition.
i am new to excel and not familiar with excel programming. Is there a
way to get this done. Need help urgently

Thanks
Manan


--
manan
------------------------------------------------------------------------
manan's Profile: http://www.excelforum.com/member.php...o&userid=34216
View this thread: http://www.excelforum.com/showthread...hreadid=541473

I've been trying to get a solution with a single formula.

Till now, I only have a solution with a staging row in DB6O6 with formula:
=AND(DB5/$AE5>=0.8,DB5/$AE5<=1.2)

The final result in DP5 is given by formula:
=INDEX(DB4O4,1,MATCH(TRUE,DB6O6,0))

See example: http://cjoint.com/?fmnCEWBPcI

HTH
--
AP

"manan" <(E-Mail Removed)> a écrit dans le
message de news: (E-Mail Removed)...
>
> Hi
>
> I have a a range of cell lets say db5:do5. I need to check which is the
> first value in this range whcih is between 80% to 120% of ae5. In cell
> dp5 i need excel to return the column heading (range db4:db5) of the
> cell which meets the above said condition.
> i am new to excel and not familiar with excel programming. Is there a
> way to get this done. Need help urgently
>
> Thanks
> Manan
>
>
> --
> manan
> ------------------------------------------------------------------------
> manan's Profile:
> http://www.excelforum.com/member.php...o&userid=34216
> View this thread: http://www.excelforum.com/showthread...hreadid=541473
>

Hi
thanks for your reply. I managed too get it done in stages. Its not
necessary to do it in one formula.
Thanks


--
manan
------------------------------------------------------------------------
manan's Profile: http://www.excelforum.com/member.php...o&userid=34216
View this thread: http://www.excelforum.com/showthread...hreadid=541473