In a table of data, I need to match 3 variables and select the corresponding value.
Between the 3 variables, there should only be one match.
For the life of me, I can't sort this out :(
I've simplified in the attached screenshot, and attached a sample excel.
View best response
To get the expected result in D15 you have to change the text in B15.
I get a #VALUE! result with that, when trying as either a formula or array formula.
I forgot to mention that you have to delete the hyphen in C6 and D6