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:
www.dropbox.com/scl/fi/r5yj9usn997o76ow6qm5s/Help.xlsx?dl=0&rlkey=a1qwtm8we2twctnfvs9qoefyh
sheet 1:
sheet2:
Sheet3 (result):
Thank you in advance to anyone who is kind enough to help
Jack
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:
www.dropbox.com/scl/fi/r5yj9usn997o76ow6qm5s/Help.xlsx?dl=0&rlkey=a1qwtm8we2twctnfvs9qoefyh
sheet 1:
sheet2:
Sheet3 (result):
Thank you in advance to anyone who is kind enough to help
Jack