Excel IF...THEN

Quiet1 · Jun 24, 2005

Bid
=INDEX(A2:A13,COUNTIF(A2:A13,">"&A15)+1,1)
Ask
=INDEX(A2:A13,COUNTIF(A2:A13,">"&A15),1)

FuturesTrader71 · Jun 24, 2005

Quote from Quiet1:

Bid
=INDEX(A2:A13,COUNTIF(A2:A13,">"&A15)+1,1)
Ask
=INDEX(A2:A13,COUNTIF(A2:A13,">"&A15),1)

That worked. I didn't enter it correctly. I have never used the INDEX function, so this is a welcome lesson.

I appreciate your help.