you need to use absolute references for the source table:
Using this formula will allow you to fill down with the same formula and the relative references will adjust correctly and the absolute references will remain unchanged.
That is the range for looking up the information should remain the same (or absolute).
You can get details regarding relative and absolute references from the Numbers Users Guide which is a free download from :
Chapter 6 may be of particular help