Hi,
In one sheet I have primary (2 crushers, different manufacturer), secondary (4 crushers, 2 different manufacturer) and terciary crushers (6 crushers and 3 different manufacturer) and years of their production.
In second sheet i have in column A years and in row 1 (index) years, primary, secondary, terciary
inner and outer shell in older crushers, they are consumed faster and there are dimensional difference between primary, secondary and terciary crushers.
What i need is to get in sheet 1 in column D data from 2nd sheet on 2 criteria.
1 criteria is years (how old is crusher) from column A
2nd criteria is type of crusher from row 1 (B, C, D)
in 1st sheet years is under column B, type of crusher is under column C, and inner shell is under column E
In one sheet I have primary (2 crushers, different manufacturer), secondary (4 crushers, 2 different manufacturer) and terciary crushers (6 crushers and 3 different manufacturer) and years of their production.
In second sheet i have in column A years and in row 1 (index) years, primary, secondary, terciary
inner and outer shell in older crushers, they are consumed faster and there are dimensional difference between primary, secondary and terciary crushers.
What i need is to get in sheet 1 in column D data from 2nd sheet on 2 criteria.
1 criteria is years (how old is crusher) from column A
2nd criteria is type of crusher from row 1 (B, C, D)
in 1st sheet years is under column B, type of crusher is under column C, and inner shell is under column E