Thanks for the advice. However, the values in column A and B are random, 4
being in middle is just a coincidence so I don't think it works.
I did a little bit search and found a MATCH function that will return the
NUMBER of match data entry, like if I MATCH with coefficient 4, it returns 2,
meaning 2 entries of "4" in column A.....dunno if this could help


"Mike H" wrote:

Hi,

Try this. The 4 in the middle of the formula is the lookup value

=LOOKUP(2,1/(A1:A20=4),B1:B20)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.