I have a problem with using the MATCH formula to return the correct 'ranking' from my named array.
I have the following:
Cell Q3 - with options VL,L,M,H,VH
Cell R3 - with options VL,L,MLH,VH
Cell T3 should return an overall rating depending on what the user has selected from Cell Q3 and R3...