Please give some further details. Are you looking for data which can
be on a number of sheets which are then added together, or does the
data only occur on one of many sheets? Post an example of your
formula.

Pete

On Dec 17, 8:40*am, zee wrote:
Am trying to lookup data from different worksheets in the single workbook..
Using vlook function but is very time consuming, doing the vlook for every
sheet.
can i do a vlookup for multiple sheets. or in other words add more then one
table arrays in the vlookup function?