lookup and give an array/list

[livinglegend629]

I have tried using index() and match() to try and lookup a value in one column and give me the value in the corresponding row. Here is what the table looks like:

PO Number Next Date Due Status
30011-11 x/xx/xx OK
30012-11 x/xx/xx Pending
30013-11 x/xx/xx URGENT
30014-11 x/xx/xx PAST DUE

The status is based on how many days before the PO is due. I want to be able to create a column that lists which PO's are in a certain status. I tried looking up all the ones that are urgent using index and match and having it tell me the PO number but it would only give me one response. I tried using ctrl-shift enter to see if I could make an array but it would just give me an array of the same PO number. Am I missing something or is there another way to do this??

I've tried searching for something like this but I haven't seen anything using vlookup,hlookup,index,match that will give an array BUT I apologize if this is has already been answered somewhere else. I'd appreciate any help i can get and thank you ahead of time.