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