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