Thanks to all of you... I got it working... now just need to copy it to all
the other cells. Thanks again.

"Spiky" wrote:

On Aug 29, 11:33 am, Flcnmech
wrote:
I guess I am not following the enter it as an Array Formula
(Ctrl-Shift-Enter) I am typing the equation into the cell. When I have the
cell active and hit the keystroke nothing happens.

When you are done typing the formula, or pasting it, hold down CTRL
and SHIFT, then press Enter. Usually you just press Enter, which isn't
enough in this case. You can tell the difference because Excel will
put braces {} around the entire formula, like this:

{=INDEX(Data!G1:G4,MATCH(Results!A2&Results!B1,Dat a!A1:A4&Data!
B1:B4,0))}

And by "I have the cell active", I'm guessing you mean you have it
"selected" if it hasn't worked so far. You actually have to be in Edit
mode, where there is a cursor blinking in the formula bar.