Spreadsheet: 872754d1719177958-3-way-index-match-xlookup-sample-excel-forum-solution-
Sheet: Sheet4

Title | Region | 0.25 | 0.5 | 0.75 | 0.9 |  |  |  |  | Function | Title | P Value | Day Rate | Solution 1 | Solution 2
Director | Commercial Central | 664 | 768 | 795 | 811 |  |  |  |  | PM Central | Director | 0.5 | 549
PD | Commercial Central | 567 | 599 | 611 | 631 |  |  |  |  | PM SE | Senior | 0.5 | 359 | 359 | 359
AD | Commercial Central | 444 | 456 | 462 | 481 |  |  |  |  | PM Central | Trainee | 0.75 | 93 | 93 | 93
Senior | Commercial Central | 316 | 336 | 362 | 385 |  |  |  |  | Commercial Central/NW | AD | 0.5 | 456 | 456 | 456
Professional | Commercial Central | 239 | 264 | 281 | 305 |  |  |  |  | Commercial Central/NW | Professional | 0.5 | 256 | 256 | 256
Assistant | Commercial Central | 145 | 153 | 161 | 188 |  |  |  |  | Commercial SE | Director | 0.25 | 681 | 681 | 681
Trainee | Commercial Central | 103 | 109 | 115 | 118 |  |  |  |  | Commercial SE | AD | 0.9 | 576 | 576 | 576
 |  |  |  |  |  |  |  |  |  | Commercial SE | PD | 0.75 | 677 | 677 | 677
Director | Commercial NW | 578 | 644 | 649 | 652 |  |  |  |  | Commercial SE | Senior | 0.25 | 339 | 339 | 339
PD | Commercial NW | 613 | 660 | 707 | 736 |  |  |  |  | Commercial SE | Trainee | 0.25 | 114 | 114 | 114
AD | Commercial NW | 432 | 446 | 505 | 549 |  |  |  |  | Commercial NW | Director | 0.75 | 649 | 649 | 649
Senior | Commercial NW | 316 | 329 | 368 | 385 |  |  |  |  | Commercial NW | Senior | 0.9 | 385 | 385 | 385
Professional | Commercial NW | 233 | 251 | 266 | 289 |  |  |  |  | Commercial NW | Professional | 0.9 | 289 | 289 | 289
Assistant | Commercial NW | 143 | 146 | 158 | 189
Trainee | Commercial NW | 126 | 131 | 135 | 138
Director | Commercial Central/NW | 582 | 649 | 739 | 795
PD | Commercial Central/NW | 565 | 599 | 621 | 682
AD | Commercial Central/NW | 432 | 456 | 468 | 516
Senior | Commercial Central/NW | 315 | 335 | 368 | 386
Professional | Commercial Central/NW | 236 | 256 | 277 | 292
Assistant | Commercial Central/NW | 144 | 150 | 161 | 195
Trainee | Commercial Central/NW | 115 | 121 | 126 | 135
Director | Commercial SE | 681 | 701 | 723 | 768
PD | Commercial SE | 616 | 641 | 677 | 735
AD | Commercial SE | 479 | 520 | 541 | 576
Senior | Commercial SE | 339 | 380 | 404 | 432
Professional | Commercial SE | 253 | 277 | 296 | 304
Assistant | Commercial SE | 161 | 164 | 177 | 198
Trainee | Commercial SE | 114 | 132 | 137 | 137
Director | PM Central | 549 | 549 | 549 | 549
PD | PM Central | 543 | 543 | 543 | 543
AD | PM Central | 456 | 462 | 465 | 478
Senior | PM Central | 329 | 348 | 364 | 380
Professional | PM Central | 232 | 261 | 279 | 305
Assistant | PM Central | 145 | 161 | 204 | 232
Trainee | PM Central | 93 | 93 | 93 | 93
Director | PM NW | 633 | 641 | 649 | 653
PD | PM NW | 533 | 555 | 576 | 589
AD | PM NW | 427 | 428 | 429 | 429
Senior | PM NW | 317 | 330 | 342 | 357
Professional | PM NW | 235 | 254 | 283 | 286
Assistant | PM NW | 145 | 158 | 163 | 187
Trainee | PM NW
Director | PM Central/NW | 587 | 626 | 641 | 650
PD | PM Central/NW | 527 | 543 | 571 | 587
AD | PM Central/NW | 450 | 457 | 465 | 471
Senior | PM Central/NW | 321 | 342 | 359 | 372
Professional | PM Central/NW | 234 | 259 | 282 | 304
Assistant | PM Central/NW | 145 | 161 | 188 | 209
Trainee | PM Central/NW | 93 | 93 | 93 | 93
Director | PM SE | 622 | 642 | 779 | 862
PD | PM SE | 614 | 658 | 705 | 722
AD | PM SE | 459 | 484 | 504 | 535
Senior | PM SE | 327 | 359 | 399 | 414
Professional | PM SE | 245 | 267 | 279 | 303
Assistant | PM SE | 161 | 163 | 177 | 178
Trainee | PM SE | 113 | 126 | 142 | 150