would you elaborate more?
In which Sheet are your lookup value?
Where will be your table arrays and which column do you want to return the
value?
Are your tables in your other sheets identical?

"jedman" wrote:

I am trying to use the vlookup to look at account numbers over 40 worksheets,
Is this possible to have the formula look in each worksheet without having to
type 40 different vlookups? I tried naming the range on each worksheet and
that is not working