Hi,

Maybe somebody can help me with the following:

In the main sheet I've made an totall array which has to be filled from
other arrays standing on different sheets. Normaly that is not so difficult
by using (V)lookup-formulas but now I've to check 2 parameters from the
totall array and check this into an array standing on a different sheet with
the same lay-out but normally without all the amounts of check parameters.
For example:

Totall sheet:
after one hour after two hours
249WH 273L10
273L11
273R10
273R11
250RD 165L00
165R00
273L10
273L11
347PB 165L00
165R00
273L10
273L11

Example of an array on a different sheet named "after one hour" (made by
pivot table)
249WH 273L10 2
373R11 1
347PB 165L00 3
273L11 1
Example of an array on a different sheet named "after two hours" (made by
pivot table)
250RD 165L00 1
165R00 2
The values standing in the sheets "after one and 2 hours" has to be placed
in the totall sheet on the right spot.

Does anybody have a clue and can help me?

Thanks in advance.

Greet

Hi
Can't you create another column on each sheet and combine the codes
using &? Now do VLookup on that single column.

Column1 Column2 NewColumn
249WH 273L10 =249WH&273L10
273L11 =same etc
273R10
273R11
250RD 165L00
165R00
273L10
273L11
347PB 165L00
165R00
273L10
273L11

regards
Paul

Thanks,

This is a sollution I can work with even in VBA.

Greetz.
Rob

" wrote:

Hi
Can't you create another column on each sheet and combine the codes
using &? Now do VLookup on that single column.

Column1 Column2 NewColumn
249WH 273L10 =249WH&273L10
273L11 =same etc
273R10
273R11
250RD 165L00
165R00
273L10
273L11
347PB 165L00
165R00
273L10
273L11

regards
Paul

Things would be much easier if your tables had values (copied frum row
above) in all A columns.

You could then use a SUMPRODUCT formula

HTH
--
AP

"fluffypluisje" a écrit dans le
message de news: ...
Hi,

Maybe somebody can help me with the following:

In the main sheet I've made an totall array which has to be filled from
other arrays standing on different sheets. Normaly that is not so
difficult
by using (V)lookup-formulas but now I've to check 2 parameters from the
totall array and check this into an array standing on a different sheet
with
the same lay-out but normally without all the amounts of check parameters.
For example:

Totall sheet:
after one hour after two hours
249WH 273L10
273L11
273R10
273R11
250RD 165L00
165R00
273L10
273L11
347PB 165L00
165R00
273L10
273L11

Example of an array on a different sheet named "after one hour" (made by
pivot table)
249WH 273L10 2
373R11 1
347PB 165L00 3
273L11 1
Example of an array on a different sheet named "after two hours" (made by
pivot table)
250RD 165L00 1
165R00 2
The values standing in the sheets "after one and 2 hours" has to be placed
in the totall sheet on the right spot.

Does anybody have a clue and can help me?

Thanks in advance.

Greet