match() and duplicated values

[lezawang]

Hi
I learnt how to use match() function. I have in a column 2 cells with the same value. When I tried to use match(), it returned to me the row of the first value. How that can be resolved? Thank you.

 

[Marcelo Branco]

Could you post a data sample along with expected results?

M.

 

[JumpingCrab]

MATCH() will always return the row of first value it finds that matches. It is by design. What are you trying to accomplish?

 

[lezawang]

Not trying to accomplish anything, just wanted to experiment that. wanted to know how match function would behave

name---phone#---address
jim----- 123-------100 main street
alex----444 -------300 grand street
mary----333 ------100 main street


H1= 100 main street
M1 = match(H1,C2:C20,0)

So wanted to know why match would return 1 not 3 for example. Thanks

MATCH() will always return the row of first value it finds that matches. It is by design. What are you trying to accomplish?