Nested index/match formula

Hi,

I got some great help for the attached spreadsheet last year and we have now evolved it needing more information but I cannot figure out how to get that additional information to pull through from Sheet 2.

The spreadsheet is set up to pull through certain measurements from Sheet 2 depending what suite (column B) and type (column C) is selected on Sheet 1. I now need column F in Sheet 2 to pull through to column P in Sheet 1, is someone able to help me with a formula for this? I have tried to set up by what has already been done but it is outside of my skill set.

Also hoping the formulas can include something to show a blank cell instead of the #N/A as this is a spreadsheet that will be going to clients and will be tidier and less confusing for user if the error isn't shown.

Thank you in advance for the help, I am personally trying to learn more about Excel to help with my work but this many nested formulas and pulling through from named ranges is outside what I'd learnt. If you can advise a good place to learn and practice this I would really appreciate.

Thanks,

Emma