Formula to get multiple results

[mentikk]

Hi,
I'm looking for help to get a formula to receive all matching results. So far I get just the first one.
In worksheet "IWKA" I need to get list of values in column Zlecenie (column A). As you can see I have formula in cell A3 and do not know how to get next results for A4, A5 etc as far as there are matching results.
Values should be from worksheet "zrzut" and the criteria is that it gets all values with IWKA in column I (WC).
The thing is that data in worksheet are about to be updated/changed every day nad there may be different amount of those - sometimes 1000, sometimes 1500.
If there is an option I would also like to find out how to add another criteria - take a column C (status) and get only values between 20 and 40.
http://asset-b.soup.io/asset/6619/7177_b5e5.xlsx
Thank you for any help

 

[mentikk]

There are no registers that meet the conditions: Column I = D1 (IWKA) and Status between 20 and 40.

That's why you are getting only empty cells as results with the second formula.

M.

The thing is that "zrzut" worksheet is snapshot of the system, and column C (status) is formated as text (showed as error) and I have to manually convert it into number.
Now trying to find out if it can be done automatically with macro
So it's working properly, as it should.
Thanks for help, and sorry for trouble.

 

[Ashish Saini]

it's working for me