Multiple returns in-line

Hi All,

I have a question similar to the below post, however I can't seem to get it working for me in excel tables to make the process more "editable friendly".

http://www.excelforum.com/excel-gene...ence-cell.html

Document I'm working on:
HSE Register.xlsx

What I am aiming for is:
"Actions" (Sheet 1 - Column I) is to be a locked cell with the formula.
It is to return the following:
IF "ID" (Sheet 1 - Column A) is equal to "Ref ID" (Sheet 2 - Column B)
Then it would return the corresponding "Action ID" (Sheet 2 - Column A) to "Actions" (Sheet 1 - Column I) in-line separated by a comma e.g. Actions would = A01, A02.

It seems simple enough, I'm just not having much luck.

I would appreciate any help on the matter.

Thanks.

GS

Not quite it, but thanks GeneralDisarray.

I have modified the attachment to show the result I am looking for.
The purpose of the formula is to automatically track the "Action ID" numbers assigned to items.
e.g. Pumps are a problem(Item) - I assign actions to fix the item (A01, A02). When the actions have been entered into the Action Register they automatically appear in the Item Register (as shown in the attachment). So one item may have many actions assigned to it, this is just a way of tracking them.

I hope that makes sense.

Thanks.

HSE Register2.xlsx

What ever is the easiest way to make it happen. I'm not that up on VBA or Macros in excel but if it works it works.

Thanks.

Thanks GeneralDisarray. Just what I was looking for!