Spreadsheet: 748316d1632069044-range-from-criteria-book1_solution
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | INDEX(C3:E11,MATCH(H2,B3:B11,0),MATCH(H3,C2:E2,0))
Species |  | Code | Prov | size | age | ea | Tarriff | No | AMOUNT |  | MIN | MAX | RANGE | Size | Tarriff |  | price
[NAME] | Pedunculate oak |  |  | 20-30cm |  |  |  | 10 |  |  | 0 | 11 | 0-10 | 20-30cm | T1 | >10 | 1
Quercus Petraea | Sessile oak |  |  | 20-30cm |  |  |  | 200 |  |  | 10 | 101 | 11-100 | 20-30cm | T1 | >100 | 2
Betula pendula | Silver Birch |  |  | 30-50cm |  |  |  | 20 |  |  | 100 | 1001 | 101-1000 | 20-30cm | T1 | >1000 | 3
Betula pubescens | Downy Birch |  |  | 20-30cm |  |  |  | 20 |  |  | 0 | 11 | 0-10 | 20-30cm | T2 | >10 | 4
Castanea sativa | [NAME] |  |  | 20-30cm |  |  |  | 5 |  |  | 10 | 101 | 11-100 | 20-30cm | T2 | >100 | 5
Tilia cordata | Small Leaf Lime |  |  | 30-50cm |  |  |  | 20 |  |  | 100 | 1001 | 101-1000 | 20-30cm | T2 | >1000 | 6
Prunus avium | Wild Cherry |  |  | 30-50cm |  |  |  | 30 |  |  | 0 | 11 | 0-10 | 30-50cm | T1 | >10 | 7
Alnus Glutinosa | Alder |  |  | 30-50cm |  |  |  | 40 |  |  | 10 | 101 | 11-100 | 30-50cm | T1 | >100 | 8
[NAME] | [NAME] |  |  | 20-30cm |  |  |  | 30 |  |  | 100 | 1001 | 101-1000 | 30-50cm | T1 | >1000 | 9
Crataegus Monogyna | Hawthorn |  |  | 20-30cm |  |  |  | 30 |  |  | 0 | 11 | 0-10 | 30-50cm | T2 | >10 | 10
Salix caprea | Goat Willow |  |  | 20-30cm |  |  |  | 20 |  |  | 10 | 101 | 11-100 | 30-50cm | T2 | >100 | 11
Rhamnus cathartica | [NAME] |  |  | 20-30cm |  |  |  | 15 |  |  | 100 | 1001 | 101-1000 | 30-50cm | T2 | >1000 | 12
Sorbus aucuparia | [NAME] |  |  | 30-50cm |  |  |  | 20
Acer campestre | Field Maple |  |  | 20-30cm |  |  |  | 20
 |  |  |  | 20-30cm |  |  |  | 20
 |  |  |  | 20-30cm |  |  |  | 20
Prunus Spinosa | Blackthorn |  |  | 20-30cm |  |  |  | 30
Sambucus nigra | Elder |  |  | 20-30cm |  |  |  | 30
Malus sylvestris | Crab Apple |  |  | 20-30cm |  |  |  | 30
Euonamus europus | Spindle |  |  | 20-30cm |  |  |  | 20
 |  |  |  |  |  |  |  | TOTAL
Species | TT Code | Qty (No. ) | Master Cert No.* | Type of basic [NAME] | Category2 | National Register of Basic Material | Tarriff | Origin5 | Age and type of plants6 | Nature7 |  | Veg. [NAME]. (Y/N)
(botanical name) |  |  |  |  |  | identities3, 4
Acer campestre | Be20 |  | EU/UK/20200586 | RP | SI | acaRP403SI | T2 | Unknown | P2 | Plants |  | N
Acer pseudoplatanus | Y16 |  |  |  |  | 305 | T1 | Unknown |  | Plants |  | N
Aesculus hippocastanum | B18 |  |  |  |  | 305 | T2 | Unknown |  | Plants |  | N
Alnus glutinosa | G19 |  | EU/UK/20170323 | RP | SI | aglRP403SI | T1 | Unknown | P1 | Plants |  | N
Alnus glutinosa | Be20 |  | EU/UK/20190264 | RP | SI | aglRP403SI | T1 | Unknown | P1 | Plants |  | N
Alnus glutinosa | ALBA |  | EU/UK/20190405 | RP | SI | aglRP304SI | T1 | Unknown | P1 | Plants |  | N
Betula pendula | G19 |  | EU/UK/2019185 | RP | SI | bpeRP403SI | T2 | Unknown | P2 | Plants |  | N
Betula pendula | Be20 |  | EU/UK/2020597 | RP | SI | bpeRP403SI | T2 | Unknown | P2 | Plants |  | N
Betula pendula | ALBA |  | EU/UK/20190217 | RP | SI | bpeRP108SI | T2 | Unknown | P4 | Plants |  | N
Betula pubescens | B18 |  |  |  |  | 305 | T1 | Unknown |  | Plants |  | N
Carpinus betulus | Be20 |  | EU/UK/20200198 | RP | SI | cbeRP405SI | T2 | Unknown | P1 | Plants |  | N
Castania sativa | R17 |  | EU/UK/20180423 | RP | SI | qpeRP305SI | T2 | Unknown | P4 | Plants |  | N
Corylus avellana | Be20 |  | EU/UK/20190618 | RP | SI | cavRP405SI | T2 | Unknown | P1 | Plants |  | N
Corylus avellana | ALBA |  | EU/UK/20180587 | RP | SI | cavRP405SI | T2 | Unknown | P1 | Plants |  | N
Crataegus monogyna | G19 |  | EU/UK/20190175 | RP | SI | cmoRP404SI | T1 | Unknown | P2 | Plants |  | N
Crataegus monogyna | Be20 |  | EU/UK/20200146 | RP | SI | cmoRP303SI | T1 | Unknown | P1 | Plants |  | N
Euonamus europus | Be20 |  | EU/UK/20200620 | RP | SI | eeuRP403SI | T2 | Unknown | P1 | Plants |  | N
Euonamus europus | ALB |  | EU/UK/20190620 | RP | SI | eeuRP403SI | T2 | Unknown | P4 | Plants |  | N
Fagus sylvatica | G19 |  | EU/UK/20190270 | ST | SE | fsyST40-30SE | T1 | Unknown | P4 | Plants |  | N
Fagus sylvatica | Be20 |  | EU/UK/20190269 | ST | SE | fsyST20-04SE | T1 | Unknown | P4 | Plants |  | N
Ilex aquifolium | ALBA |  | EU/UK/20150434 | RP | SI | iaqRP405SI | T2 | In | P4 | Plants |  | N
Malus sylvestris | G19 |  | EU/UK/20200213 | RP | SI | msyRP405SI | T1 | Unknown | P2 | Plants |  | N |  |  |  |  | T2
Malus sylvestris | Be20 |  | UK/20210138 | RP | SI | msyRP405SI | T1 | Unknown | P1 | Plants |  | N |  |  |  |  | T2
Pinus sylvestris | Y16 |  |  |  |  |  | T1 |  |  | Plants |  | N
Prunus avium | G19 |  | EU/UK/20180484 | RP | SI | pavOR5QU | T1 | Unknown | P2 | Plants |  | N
Prunus avium | G19 |  | EU/UK/20180485 | RP | SI | pavOR6QU | T1 | Unknown | P1 | Plants |  | N
Prunus padus | Be20 |  | EU/UK/20200635 | RP | SI | ppdRP403SI | T1 | Unknown | P1 | Plants |  | N
Prunus spinosa | Be20 |  | EU/UK/20200274 | RP | SI | pspRP403SI | T1 | Unknown | P1 | Plants |  | N
Prunus spinosa | ALBA |  | EU/UK/20190333 | RP | SI | pspRP403SI | T1 | Unknown | P1 | Plants |  | N
Quercus robur | R17 |  |  | RP | SI |  | T2 | Unknown | P4 | Plants |  | N |  |  |  |  | T2
Quercus petraea | R17 |  | EU/UK/20180421 | RP | SI | qpeRP305SI | T2 | Unknown | P4 | Plants |  | N |  |  |  |  | T2
Rhamnus cathartica | G19 |  | EU/UK/20200225 | RP | SI | rcaRP403SI | T1 | Unknown | P2 | Plants |  | N
Salix caprea | [NAME] |  |  |  |  |  | T1 |  |  | Plants |  | N
Salix cinerea | [NAME] |  |  |  |  |  | T1 |  |  | Plants |  | N
Sambucus nigra | Be20 |  | EU/UK/20120005 | RP | SI | sniRP403SI | T2 | Unknown | P1 | Plants |  | N
Sambucus nigra | ALBA |  | EU/UK/20160193 | RP | SI | sniRP204SI | T2 | Unknown | P1 | Plants |  | N
Sorbus aria | Be20 |  | EU/UK/20200104 | RP | SI | sarRP403SI | T2 | Unknown | P1 | Plants |  | N
Sorbus aucuparia | G19 |  | EU/UK/20190644 | RP | SI | sacRP303SI | T1 | Unknown | P2 | Plants |  | N
Sorbus aucuparia | Be20 |  | EU/UK/20170287 | ST | SI | sacST40-01SI | T1 | Unknown | P1 | Plants |  | N
Sorbus torminalis | Be20 |  | EU/UK/20170287 | RP | SI | stoRP403SI | T2 | Unknown | P1 | Plants |  | N
Taxus baccata | G19 |  | EU/UK/20190644 | RP | SI | tbaRP403SI | T2 | Unknown | P2 | Plants |  | N
Taxus baccata | Be20 |  | EU/UK/20200108 | RP | SI | tbaRP403SI | T2 | Unknown | P1 | Plants |  | N
Tilia cordata | Y16 |  |  |  |  | tbaRP403SI | T2 |  |  | Plants |  | N