Spreadsheet: 115593d1311168815-vlookup-and-dynamic-ranges-book3
Sheet: Mon

1 |  | MPRN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB [NAME]? (YES OR NO)
Job1 |  | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job2 |  | 1001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job3 |  | 1002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job4 |  | 1003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job6 |  | 1005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job7 |  | 1006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job8 |  | 1007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job9 |  | 1008 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job10 |  | 1009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job11 |  | 1010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job13 |  | 1012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job15 |  | 1014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job16 |  | 1015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job17 |  | 1016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job20 |  | 1019 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job21 |  | 1020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job23 |  | 1022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job24 |  | 1023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job25 |  | 1024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1025 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job27 |  | 1026 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1027 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job29 |  | 1028 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job30 |  | 1029 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job31 |  | 1030 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job32 |  | 1031 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job33 |  | 1032 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1033 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job35 |  | 1034 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job36 |  | 1035 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1036 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job39 |  | 1038 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no
Job40 |  | 1039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1041 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job43 |  | 1042 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1043 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job45 |  | 1044 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job46 |  | 1045 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job47 |  | 1046 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1047 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job49 |  | 1048 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job50 |  | 1049 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1050 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1051 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1052 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job54 |  | 1053 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job55 |  | 1054 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job56 |  | 1055 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job57 |  | 1056 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job58 |  | 1057 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job59 |  | 1058 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1059 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job61 |  | 1060 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job62 |  | 1061 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job63 |  | 1062 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job64 |  | 1063 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job65 |  | 1064 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job66 |  | 1065 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job67 |  | 1066 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job68 |  | 1067 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job69 |  | 1068 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job70 |  | 1069 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job71 |  | 1070 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1071 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job73 |  | 1072 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1073 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job75 |  | 1074 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job76 |  | 1075 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1076 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job78 |  | 1077 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1078 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job80 |  | 1079 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job81 |  | 1080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job82 |  | 1081 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes
Job83 |  | 1082 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1083 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1084 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1085 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job87 |  | 1086 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
Job88 |  | 1087 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
Job89 |  | 1088 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
[NAME] |  | 1089 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
[NAME] |  | 1090 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES