Spreadsheet: 328240d1403832119-median-indirect-find-median-in-range-and-bring-back-adjacent-cells-median-and-bring-back-adjacent-cell-example
Sheet: DATA MERGE

1 |  |  |  | 3 | 4 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  | OrgCategories
RowID | UniCode | Level 1 | Level 2 | Cost (P$M) | [NAME] | Central | Central Other | FC | Ins | Sch
05403. Human Resources03.01 Payroll&Sup | 54 | 03. Human Resources | 03.01 Payroll&Sup |  |  | 0.7012345679012346 | 0.01907968574635233 | 0.1020763187429854 | 0.00718294051627385 | 0.1704264870931538
05803. Human Resources03.01 Payroll&Sup | 58 | 03. Human Resources | 03.01 Payroll&Sup |  |  | 0.7435840071590654 | 0.01818530473968505 | 0.1146089680079261 | 0 | 0.1236217200933235
05603. Human Resources03.01 Payroll&Sup | 56 | 03. Human Resources | 03.01 Payroll&Sup |  |  | 0.3694736492985308 | 0.05276773573015814 | 0.3092766409074326 | 0 | 0.2684819740638785
05703. Human Resources03.01 Payroll&Sup | 57 | 03. Human Resources | 03.01 Payroll&Sup |  |  | 0.4651162790697674 | 0.07610993657505294 | 0 | 0 | 0.4587737843551796
05903. Human Resources03.01 Payroll&Sup | 59 | 03. Human Resources | 03.01 Payroll&Sup |  |  | 0.4983983787670785 | 0.1052493953062692 | 0 | 0 | 0.3963522259266523
05403. Human Resources03.02 EmpAdvisor | 54 | 03. Human Resources | 03.02 EmpAdvisor |  |  | 0.6509736932012299 | 0.06584671449720991 | 0.06040314314998292 | 0.02594237558364651 | 0.1968340735679307
05803. Human Resources03.02 EmpAdvisor | 58 | 03. Human Resources | 03.02 EmpAdvisor |  |  | 0.8418031120307137 | 0.03999473753453486 | 0.02659937089617395 | 0.006578081831337982 | 0.08502469770723947
05603. Human Resources03.02 EmpAdvisor | 56 | 03. Human Resources | 03.02 EmpAdvisor |  |  | 0.1361359596938851 | 0.2970960207993655 | 0.3728903186004495 | 0.002923074663258861 | 0.1909546262430412
05703. Human Resources03.02 EmpAdvisor | 57 | 03. Human Resources | 03.02 EmpAdvisor |  |  | 0.6027862327323812 | 0.1547646921095762 | 0.03207679700304378 | 0 | 0.2103722781549988
05903. Human Resources03.02 EmpAdvisor | 59 | 03. Human Resources | 03.02 EmpAdvisor |  |  | 0.4183875022445682 | 0.1742981983599688 | 0.07353205243311187 | 0.00299275752678518 | 0.330789489435566
05403. Human Resources03.03 StaffDev&Train | 54 | 03. Human Resources | 03.03 StaffDev&Train |  |  | 0.5441365388144613 | 0.3013396953569463 | 0.0866825717256989 | 0.01101119471462654 | 0.05682999938826696
05803. Human Resources03.03 StaffDev&Train | 58 | 03. Human Resources | 03.03 StaffDev&Train |  |  | 0.8873169725716643 | 0.04784491647762434 | 0.006516807589193648 | 0.02804702000412456 | 0.03027428335739327
05603. Human Resources03.03 StaffDev&Train | 56 | 03. Human Resources | 03.03 StaffDev&Train |  |  | 0.3447300557357957 | 0.2397471092255221 | 0.321770235421346 | 0 | 0.09375259961733633
05703. Human Resources03.03 StaffDev&Train | 57 | 03. Human Resources | 03.03 StaffDev&Train |  |  | 0.3263157894736842 | 0.369122807017544 | 0.07017543859649122 | 0 | 0.2343859649122807
05903. Human Resources03.03 StaffDev&Train | 59 | 03. Human Resources | 03.03 StaffDev&Train |  |  | 0.3508514386376982 | 0.5027891955372872 | 0.02935995302407516 | 0 | 0.1169994128009395
End | End | End | End | End | End | End |  | End | End | End
 |  |  |  |  |  | 0.6509736932012299 | 0.06584671449720991
 |  |  |  |  |  | 0.8418031120307137 | 0.03999473753453486
 |  |  |  |  |  | 0.1361359596938851 | 0.2970960207993655
 |  |  |  |  |  | 0.6027862327323812 | 0.1547646921095762
 |  |  |  |  |  | 0.4183875022445682 | 0.1742981983599688
 |  |  | This is the condition Column, the  formula must be able to check if the data  in this column is equal to a cell value |  |  | Median | [NAME]:
 |  |  |  |  |  |  | Should return 15.5 as it’s the closest to the Median value in H - Is this possible?