POSITION OF CELL VALUE IN A RANGE

[pucha]

POSITION OF CELL VALUE IN A RANGE.

I WANT TO KNOW WHETHER THE OPEN PRICE IS IN "OVERSOLD ZONE" OR IN "OVER BOUGHT ZONE".

THANKS

PUCHA

 

[Hui]

I would add a helper column G which has the Over Bought/Over Sold values in each cell
then use a formula: =INDEX(G4:G100,MATCH(R52,K4:K100,-1),0)
see attached file:

 

[bosco_yip]

Another option without helper.

1] Fill empty cell H37 with "Fourth High" or other wording

2] In R53, enter formula :

=INDEX(LOOKUP(ROW($K$4:$K$100),ROW($K$4:$K$100)/($H$4:$H$100>0),$H$4:$H$100),MATCH(R52,K4:K100,-1),0)

3] See attached file

Regards
Bosco

 

[pucha]

Thank you very much Mr. Hui. for solving the problem.

and I also thanks to Mr. Bosco for doing it by another method. Both the methods are working.

With Respect & Regards to both of you,
Thanks
Pucha