Index/Match based on multiple criteria

[BB1972]

Hello guys,

Hoping I can get yet some more assistance from you kind people.

I've attached a file which contains columns of numbers, names, 2 criteria columns, and a rate column. What I'm trying to do is to type a name into B19, and have (in the attached example) a value returned for that name, provided the criteria in columns C & D ("yes" & "full") are met.

I've made an attempt at an Index/Match formula that I though should work, but am getting a #Value error. In this example, the value returned should be E8 - "100" - as this is the cell which matches the name query in B19, and which has corresponding values of "yes" & "full".

Any help would be much appreciated.

Thank you,

Brendan.