vlookup, table_array in several sheets

Hello.

I have a master sheet with unique objectnumbers, and than five subsheets where these numbers occur along with a value that I want to display in the master sheet. Using vlookup in one of the sheets works fine, but is there any way to make an array with the values from each subsheet, and than use vlookup on this array.

Thanks.

You can use MoreFunc's THREED. The add-in and related information can be found at the following links....

http://xcell05.free.fr/
http://www.rhdatasolutions.com/morefunc/#THREED

If you'd rather not install the add-in, a formula can be provided. If so, can you provide some details as to the layout of your spreadsheet?

Hope this helps!

I will try to specify my problem a bit closer:

Sheet 2 to 5 are edited by several persons, and display project numbers along with a percentage value displaying the progress in the project.

Sheet 1 has a overview of every project in sheet 2 to 5.

I want to display the percentage value on each project in sheet 1.

Each project number is unique.

It looks something like this

Sheet 1 Sheet 2 Sheet 3 osv.
A B A B A B
ID % ID % ID %
101 60 101 60 102 30
102 30 103 90
103 90



Hope this specifies the problem well.

Thanks, stakle

Since the same project is listed in each of the sheets, Sheet2 to Sheet5, how would the results for Sheet1 look like?

Sheet 2 to 5 contain individual project id`s,
but the syntax in my previous post was rather messed up.



The problem as I saw it was to use vlookup on several sheets, ie.
define the table_array over several sheets.

But I found a workaround for the problem.

Thanks for your help

stakle