At work I have a number of workbooks that contain a summary page and a number
of other pages all in the same format. Is there a formula which can automate
the table array a lookup function will lookup in the summary page? At
present I have to copy the formula down then change the table_array manually.