Thread moved to programming please ignore

[Libster78]

THIS THREAD HAS BEEN MOVED TO EXCEL PROGRAMMING!!!

Hi there,

I'm not entirely sure what I need. I know this can be done as I have done it before a long time ago but I can not remember how to do it.

I have attached the sheet with an example on it.

What I would like is for the follow cell next to compliancy to return names of document as per column headers th
at are missing as per the IF functions in the calculation for compliancy.

i.e. For EL OE I need to have an either and engagement letter open ended, a budget agreed, and a terms and conditions or an Engagement Letter open ended, an Unsigned EL and Terms and conditions. I have put an IF formula which tells you if it is compliant or not but what I need now is for it to return the documents that are needed if not compliant.
Any help gratefully received.

Many Thanks
Libby