Hello, I would like to use VLOOKUP to find out all the results of the Lookup value.
For example, I want to find the all amounts of A, it can only show the first row result.
In fact, I want to show out the results of A in order as shown in the following picture.
Anyone can help me to make this formula? Thank you very much.
candyfrog 發表於 14-11-16 01:31
... I want to show out the results of A in order as shown in the following picture.
Anyone can help me to make this formula?