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