Spreadsheet: 770423d1646060140-return-value-if-any-exist-02-26-22-sample-for-thread-return-value-if-any-exist
Sheet: Sheet1

 |  |  |  |  | IF(VLOOKUP([@[Item No.]],LotBased,2,FALSE)="n/a","NO",IF(VLOOKUP([@[Item No.]],LotBased,2,FALSE)="Lot needed","Need Lot","Yes"))
Item No | Lot Number |  |  | Item No. | LotCtrl
BRD003 | N/A |  |  | BOX001
BRD033 | N/A |  |  | BOX003
BRD033 | N/A |  |  | BOX005
BRD033 | N/A |  |  | BOX006
BOX005 | N/A |  |  | BOX007
BOX006 | N/A |  |  | BOX008
FLM002 | N/A |  |  | BOX009
FLM003 | N/A |  |  | BOX013
FLM058 | N/A |  |  | BOX035
N/A | N/A |  |  | BOX036
BOX001 | N/A |  |  | BRD003
BOX013 | N/A |  |  | BRD033
BOX035 | N/A |  |  | BRD042
BRD042 | N/A |  |  | CER031
N/A | N/A |  |  | CER033
N/A | N/A |  |  | CHE025
SNK162 | N/A |  |  | CHI035A
N/A | N/A |  |  | CHI040
CER033 | LOT NEEDED |  |  | CON001
SNK018 | 344112 |  |  | CON003
SNK022 | 338506 |  |  | CON004
SNK097 | LOT NEEDED |  |  | CON005
SNK137 | 342151 |  |  | CON006
SNK137 | 342151 |  |  | CON010
SNK182 | 342665 |  |  | CON011
SNK199 | 340505 |  |  | CON021
SNK199 | 340505 |  |  | CON022
CON001 | LOT NEEDED |  |  | DRI027
CON006 | LOT NEEDED |  |  | DRI042
CON010 | 339790 |  |  | DRI043
DRI027 | LOT NEEDED |  |  | DRI044
DRI027 | 344751 |  |  | DRI065
DRI066 | LOT NEEDED |  |  | DRI066
DRI072 | LOT NEEDED |  |  | DRI072
SNK092 | LOT NEEDED |  |  | FLM002
UTE002 | N/A |  |  | FLM003
CHI040 | 341065 |  |  | FLM016
CON004 | LOT NEEDED |  |  | FLM018
CON005 | LOT NEEDED |  |  | FLM021
CON011 | 343827 |  |  | FLM031
SNK036 | 343829 |  |  | FLM042
SNK037 | LOT NEEDED |  |  | FLM056
SNK039 | 342482 |  |  | FLM057
SNK168 | LOT NEEDED |  |  | FLM058
UTE005 | N/A |  |  | FLM066
CHI035A | LOT NEEDED |  |  | FLM067
SNK040 | LOT NEEDED |  |  | LAB003
SNK067 | 343447 |  |  | PBJ007
SNK067 | 343447 |  |  | PBJ008
CER031 | LOT NEEDED |  |  | PBJ010
DRI042 | 345032 |  |  | PBJ022
DRI043 | 345033 |  |  | SNK018
DRI044 | 344887 |  |  | SNK022
SNK142 | 343711 |  |  | SNK036
SNK143 | 343712 |  |  | SNK037
SNK153 | LOT NEEDED |  |  | SNK039
SNK154 | LOT NEEDED |  |  | SNK040
CON003 | 343017 |  |  | SNK060
DRI065 | 344285 |  |  | SNK067
DRI072 | LOT NEEDED |  |  | SNK092
PBJ008 | LOT NEEDED |  |  | SNK097
PBJ010 | 337158 |  |  | SNK109
PBJ022 | 339971 |  |  | SNK137
SNK060 | 342664 |  |  | SNK142
SNK060 | LOT NEEDED |  |  | SNK143
SNK137 | 342151 |  |  | SNK150
SNK167 | LOT NEEDED |  |  | SNK153
CHE025 | LOT NEEDED |  |  | SNK154
CON021 | 343016 |  |  | SNK162
CON021 | 334470 |  |  | SNK164
CON022 | LOT NEEDED |  |  | SNK165
CON022 | LOT NEEDED |  |  | SNK167
PBJ007 | LOT NEEDED |  |  | SNK168
SNK143 | LOT NEEDED |  |  | SNK169
SNK150 | LOT NEEDED |  |  | SNK182
SNK164 | LOT NEEDED |  |  | SNK199
SNK165 | LOT NEEDED |  |  | UTE002
N/A | N/A |  |  | UTE005
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
CHI040 | 344305
SNK018 | 344646
SNK067 | 343447
SNK137 | 344487
SNK137 | 344949
SNK182 | 343140
SNK182 | 343732
SNK182 | 343978
SNK199 | 340505
CON011 | 343827
CON022 | 343828
DRI042 | 344886
DRI044 | 344887
PBJ007 | 336815
PBJ008 | 337157
PBJ008 | 337898
PBJ008 | 338376
PBJ010 | 337158
SNK182 | 344486
CON010 | 340349
DRI066 | 050121
FLM021 | N/A
FLM031 | N/A
FLM042 | N/A
LAB003 | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
SNK037 | 343130
SNK037 | 344297
SNK037 | 342481
SNK040 | 344280
SNK168 | 340929
CHE025 | 341620
CHE025 | 341620
CHE025 | 339284
CHE025 | 337334
SNK169 | 342355
DRI072 | 341585
SNK036 | 344278
SNK036 | 342480
SNK039 | 344279
SNK039 | 344279
SNK109 | 342150
SNK167 | 340372
SNK167 | 340737
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
CHI035A | 344590
SNK060 | 343892
SNK060 | 342664
SNK060 | 343139
SNK060 | 343892
SNK060 | 343795
BOX001 | N/A
BOX006 | N/A
CER031 | 337570
CER031 | 337570
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
BOX001 | N/A
BOX003 | N/A
BOX005 | N/A
BOX006 | N/A
BOX007 | N/A
BOX008 | N/A
BOX009 | N/A
BOX013 | N/A
BOX035 | N/A
BOX036 | N/A
BOX035 | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
N/A | N/A
FLM002 | N/A
FLM003 | N/A
FLM016 | N/A
FLM057 | N/A
FLM058 | N/A
FLM067 | N/A
FLM018 | N/A
FLM021 | N/A
FLM042 | N/A
FLM056 | N/A
FLM066 | N/A
SNK150 | 345079
SNK036 | 344829
SNK036 | 342480
SNK037 | 343130
SNK039 | 342482
SNK039 | 344279
SNK150 | 345081
BRD033 | 22422
BRD033 | 22322