You probably didn't array-enter the adapted formula correctly ..

Try this:
Click inside the formula bar for J4, then press CTRL+SHIFT+ENTER
Done correctly, Excel will wrap curly braces around the formula { }. Look
out for these braces in the formula bar for J4 to confirm that you have
array-entered. If you don't see it, then the formula hasn't been
correctly array-entered.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Little Penny" wrote in message
...
Hey thanks for the help I know I'm getting close just can't get it to
work. This is my first time using index function.

=INDEX(Sheet2!$C$1:$C$1405,MATCH(1,(Sheet2!$A$1:$A $1405=E4)*(Sheet2!$D$1:$D$1405=I4),0))

I get #NA and I think it should work because on sheet 2 A26=E4 and
D26=I4 it should give me the value in cell C26 but I get #N/A in cell
J4 of sheet 1 where I entered the formula.

Any suggestions


Thanks