Hello,
I got the following setup (see below), in B5 you have a dropdown menu with a VBA code that allows to select multiple items. Those selected items will be shown in B4.
I'm trying to do the following: Look in B4 and search for the biggest number equal to that selection in range A21:B31
I also would like a formula that says "X" is the biggest category
In this it example it should show 12 in B11
I got the following setup (see below), in B5 you have a dropdown menu with a VBA code that allows to select multiple items. Those selected items will be shown in B4.
I'm trying to do the following: Look in B4 and search for the biggest number equal to that selection in range A21:B31
I also would like a formula that says "X" is the biggest category
| TCA berekening.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 3 | Parameters : ISO 22000:2018 | |||
| 4 | Categorieën?: | A, C, F, | ||
| 5 | ||||
| 6 | Aantal HACCP-plannen?: | |||
| 7 | Aantal FTE's?: | |||
| 8 | Extra site(s)?: | |||
| 9 | N/A | |||
| 10 | ||||
| 11 | Cat: | 8 | ||
| 12 | ||||
| 13 | ||||
| 14 | ||||
| 15 | ||||
| 16 | ||||
| 17 | ||||
| 18 | ||||
| 19 | ||||
| 20 | Dropdown list: Categorieën | Te besteden mandagen (uren) | ||
| 21 | A | 6 | ||
| 22 | B | 6 | ||
| 23 | C | 12 | ||
| 24 | D | 12 | ||
| 25 | E | 8 | ||
| 26 | F | 8 | ||
| 27 | G | 8 | ||
| 28 | H | 8 | ||
| 29 | I | 8 | ||
| 30 | J | 8 | ||
| 31 | K | 12 | ||
ISO22000 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A9 | A9 | =IF(B8="Ja",'ISO22000'!$F$36,"N/A") |
| B11 | B11 | =LOOKUP(1000,SEARCH('ISO22000'!$A$21:$A$31,B4),'ISO22000'!$B$21:$B$31) |
| Named Ranges | ||
|---|---|---|
| Name | Refers To | Cells |
| ISOOutput | ='ISO22000'!$B$4 | B11 |
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| B6 | List | =HACCPISO22000 |
| B7 | List | =FTEISO22000 |
| B8 | List | =ExtraSiteISO |
| B9 | List | =AantalSitesISO |
In this it example it should show 12 in B11
