As a moderate noob where arrays are concerned, I could use some guidance here. Pretty sure this would fall under the index/match function, but if there's a simpler way to arrive at a solution, I'm of course all ears.

[TABLE="width: 500"]

<tbody>[TR]

[TD]inning[/TD]

[TD]out[/TD]

[TD][/TD]

[TD]-1[/TD]

[TD]0[/TD]

[TD]1[/TD]

[/TR]

[TR]

[TD]1

[/TD]

[TD]0[/TD]

[TD][/TD]

[TD]3.3[/TD]

[TD]2.3[/TD]

[TD]5.4[/TD]

[/TR]

[TR]

[TD]1[/TD]

[TD]1[/TD]

[TD][/TD]

[TD]6.5[/TD]

[TD]3.1[/TD]

[TD]4.5[/TD]

[/TR]

[TR]

[TD]1[/TD]

[TD]2[/TD]

[TD][/TD]

[TD]5.0[/TD]

[TD]0.5[/TD]

[TD]3.0[/TD]

[/TR]

[TR]

[TD]2[/TD]

[TD]0[/TD]

[TD][/TD]

[TD]4.4[/TD]

[TD]4.1[/TD]

[TD]4.6[/TD]

[/TR]

[TR]

[TD]2[/TD]

[TD]1[/TD]

[TD][/TD]

[TD]2.2[/TD]

[TD]3.3[/TD]

[TD]5.5[/TD]

[/TR]

</tbody>[/TABLE]

Let's say the column headings "-1, 0, 1" refer to a game score.

I know how to do an array function using the inning and out columns to return a value from the center (0) column. For example, if inning = 2 and out = 0, use array index/match to return column 0 value of 4.1.

But can I also use the columns as a criteria? As in, index columns -1 through 1, and match based on say, inning = 2 outs = 0 game score = -1?

I hope I'm explaining this well enough. Please let me know.