Have a look at VLOOKUP in Help
Then come back for more info. We will need to know how the data is set out
on the worksheets
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"stuart" wrote in message
...
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.