insert data from table

i need insert data from table
problem is merged cells

if i write =index(b2:d17;e30:Ee34) IT REPORTS ERROR !

http://img156.imageshack.us/my.php?i...xcellllhy1.jpg

so i think the problem is merged cells help
cheers

can you explain in a bit more detail, what you are trying to do, as your example doesn't make sense,

can you say what is the result that you want from the table and what you need to index against.

thanks reg

from little table i choose :number of fields 1 , type of load 1..intersection of that two is m11,m22,m33,m44,m55
it s not problem me to write formula if there weren t merged cells
look column a --> it has got big cells
look column b --> it has got many little cells --> cells from a and b column are not same size becouse of that it gives me error

here s example with no error

http://img157.imageshack.us/my.php?image=correctha9.jpg
result is 33

now i need same thing only you will see i gotta merged cells and becouse of that reports me an error
result is m11,m22,m33,m44,m55


http://img156.imageshack.us/my.php?i...xcellllhy1.jpg

srry bad english :-)