Hi. I'm trying to use an match formula imbedded in an Index function to find a row which has 2 different parameters. I'm use the following formula but am getting a #N/A error return. Please can someone spot what I'm doing wrong?
I've also attached an extract (image format).
{=+INDEX(B3:D8,MATCH(F4&G3,B3:B8&C3:C8,0),4)}
Bookmarks