How do you drag down an index match function with multiple criteria?

Hi All,

I have the following index match formula in cell W3

=INDEX($R$2:$R$293,MATCH(1,($N$2:$N$293=$U3)*($L$2:$L$293=W$2),0),0)

It works like a charm but i have multiple values in column U and want to be able to drag this down in U4, U5, ... such that data from $U4 and $U5 is being pulled in. Unfortunately, if i drag this formula down and hit ctrl shift enter, all of the values still reference U3. Any idea how to get around this?

Thanks,

L

Don't fill all cells and hit ctrl shift enter...

Instead, enter it in just the first (top) cell
hit ctrl shift enter
THEN drag down.

Cheers Guys! Very helpful