Dear T. Valko,
Sorry to make your life so difficult! Really sorry about that! Indeed, the
formula which I wish to have is quite hard and challenging.

The reason why I really need to place the array formula in G1 is because
considering only a few €œOK€� (five out of 200 data) will be shown in column F.
Furthermore, I will put this array formula in other spreadsheet at the end of
the day. Finally, I want to save space as well.

Actually, before asking your advice, I was trying very hard in fitting
different database functions in array formula, of course, it failed. As a
result, under desperate situation, I have to seeking the advice from the
excel €œguru€� like you. Really appreciate your advice and time.

Once again, many thanks for your advice,
Wilchong




T. Valko wrote:
Why would the result in G1 be O when 11 is not found in the table?

This is getting harder and harder to follow!

Dear T. Valko,
Yes, you got my idea. However, I want to make the formula even smarter.
[quoted text clipped - 68 lines]
Thanks for your advice,
Wilchong

--
Message posted via http://www.officekb.com