Dear T. Valko,
Thanks, your suggested function work very well. With your suggested formula,
the €œG€� shown up in the of G2 when the formula detect €œOK€� in F2. OK, the
first step is ok already.

The second step is how to revise the formula in order to make the €œG€� shown
up in the of G1 when the formula detect €œOK€� from F1 to F10. From my
previous experience you show me, I can add €œ=IF(ROWS(G1:G$10)<=SUM(--(COUNTIF
(€¦€¦€¦€¦€¦..€� and then entered by "Shift + Control + Enter". I also dragged the
function from G1 to G10. Of course, what I tried to do was failed. As a
result, I need your advice.

Many thanks for your time.
Wilchong




T. Valko wrote:
The original formula in F1:F10 returns either a dash "-" or "OK".

Are you saying that you want another formula that checks F1:F10 for "OK" and
if found do a lookup on the entries in E1:E10?

If that's what yo want try this:

=IF(F1="OK",LOOKUP(E1,E$21:F$30),"-")

Dear T. Valko,
Thank, I know what is my problem. In order to make thing easy, I would
[quoted text clipped - 45 lines]
Thanks for your advice,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200908/1