Apologies for the inconvenience in not putting up spreadsheets last night. Also apologies for the late reply but I managed to get it to work with a few nested if/index/match functions (I'm happy to share for anyone that's interested - it may even give someone the opportunity to refine it and make it more function efficient- just let me know )

Thanks to everyone that tried to help (given I didn't articulate my problem that clearly) it is greatly appreciated.

FJMoussally signing off