What is wrong with my formula?

[jp16]

A1:A10 contain text (no duplicate). B1 contain text. I wan to return the row of A1:A10 if it equal B1.

In C1, my formula is =IF(A1:A10=B1,ROW(A1:A10)), Ctrl SHift Enter.
However, it does not work.

I know i can easily use a Match formula for this. BUt i dun understand y my formula does not work.
I am showing my colleague an example of Array formula, hence thot this is simple enough.....
Anyone can help?

[Bo_Ry]

=IF(A1:A10=B1,ROW(A1:A10))
This will return 10 result of {FALSE;… ;x,…;FALSE}, where x is row number that =B1
Select C1 and press F9 to see results

if you need row number you may try with CSE to extract number

=MIN(IF(A1:A10=B1,ROW(A1:A10))) or

=MAX(IF(A1:A10=B1,ROW(A1:A10)))

[jp16]

Hi, i tried and it work. I also tried using Large, Small and Sum. All work. So the additional function (min, max etc) is to convert the array into number? How come it does not work when i put a 1* infront or -- infront?

[avk]

Best way to attach sample file with required desired result enter manually.

[Bo_Ry]

@jp16

Please edit title

[alansidman]

@jp16

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

No further help to be offered until this request is fulfilled.