well im trying to interpolate values (the nine blank rows) between the
two original rows ....mainly i have X & Y values along with other
values but i need interpolation only for the X & Y .

you can look at this screenprint ... i think it explian

http://img436.imageshack.us/img436/1491/excel1vq.jpg

http://img436.imageshack.us/my.php?image=excel1vq.jpg