Thanks for taking the time to reply to my post. For some reason I can't download the spreadsheets that have been posted, therefore apologies if my query has already been solved within!
MrShorty, regarding a preference of which approach to take, I have none. It is how it is at present due to my limited knowledge of formulas. Whichever works is good enough for me. However, I did try your suggestion of concatenating and using a lookup but was unable to figure out how I could compare G27 (the concatenated result of the 3 sections A,B & C) which is variable depending on the answers given, to the lookup table in cells Q10:R16 then display the result in cell C27.
Any suggestions?
P.S. Just realised I can't upload my updated spreadsheetTherefore FYI the lookuptable in Q10:R16 was basically a concatenated version of the table in L11:O16.