How to use MATCH function to return multiple values

[xy.xiaoying]

Hello All,

I am trapped by this problem (as shown in subject) in Excel.

This is the table I want to deal with:

A B
1 2 4
2 4 5
3 3 2
4 2 6


I want to find out the index numbers (row number) whose value = 2 in A
column, so in this case, the return values should be 1, 4. How can I
make this happen?

Many thanks

 

[Guest]

In cell C1 enter
=IF(A1:A4=2,ROW(),"") << after typing in press Control+Shift+Enter NOT ENTER.
This is a Control array formula -- afterwards cell will look like so:
{=IF(A1:A4=2,ROW(),"")}
Copy C1 down to C4 - Only two of your row will have data in Column C 1 & 4.

Not sure this is what you want , but...

Jim May