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.