Hi there, this is my first post on this forum so sorry if i misunderstood any rules !

I am looking for help with a formula that will act between two sheets. The Formula will be on sheet two and has to:

- Add letter 'A' to 'ID'
- Display comments of 'ID' on sheet 1 beside same 'ID' on sheet 2
- Must only do this for 'flagged' 'IDs'

Sheet 3 on the attached file shows my expected results when this formula is working. Here is the file:

/scl/fi/r5yj9usn997o76ow6qm5s/Help.xlsx?dl=0&rlkey=a1qwtm8we2twctnfvs9qoefyh

It is on dropbox, please paste after standard website address

Thank you in advance to anyone who is kind enough to help

Jack