Your question sounds very similar to this discussion I participated in: http://www.excelforum.com/showthread.php?t=1145387 Note that the strategy I used was to remove the blanks from the source table to create a separate lookup table. Then perform the interpolation using the lookup table. Review the discussion and examples, and let us know what part you don't understand or get stuck on.