Spreadsheet: 831197d1685484934-need-formula-to-vlookup-value-with-criteria-result-of-product-id-nmaes_lookup_-ans-1-
Sheet: Rawdata

SL.NO | Customer Name | Category | Segment | Shipping List | Location | TodayDate | Product ID | TMS | KVS | TMS | TMS
1 | [NAME] | Furniture | Coustomer | Castlery AU | Retailer | 2023-02-27 00:00:00 | FUR-BO-10001798
2 | [NAME] | Furniture | Corporate | Interior Secrets | Retailer | 2023-02-27 00:00:00 | FUR-TA-10000577 | Not here
3 | [NAME] | Furniture | Corporate | Zanui | Retailer | 2023-02-27 00:00:00 | FUR-FU-10001487 | See …
4 | [NAME] | Furniture | Corporate | Betta Home Living | Retailer | 2023-02-27 00:00:00 | FUR-CH-10002774 | Product ID
5 | [NAME] | Furniture | Coustomer | [NAME] | Retailer | 2023-02-27 00:00:00 | FUR-TA-10000577 | … sheet
6 | [NAME] | Furniture | Corporate | [NAME] | Dealer | 2023-02-27 00:00:00 | FUR-BO-10004834
7 | [NAME] | Furniture | Coustomer | Angeletos Furniture | Dealer | 2023-02-27 00:00:00 | FUR-CH-10001146
8 | [NAME] | Furniture | Coustomer | Anibou Pty Ltd | Dealer | 2023-02-27 00:00:00 | FUR-CH-10000513
9 | [NAME] | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-FU-10000629
10 | [NAME] | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-FU-10001934
11 | [NAME] | Furniture | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-TA-10001768
12 | [NAME] | Furniture | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-FU-10002157
13 | [NAME] | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-CH-10004063
14 | [NAME] | Furniture | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-TA-10004534
15 | [NAME] | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-CH-10001146
16 | [NAME] | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-FU-10004848
17 | [NAME] | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-FU-10000521
18 | [NAME] | Furniture | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-CH-10004063
19 | [NAME] | Furniture | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-BO-10002613
20 | [NAME] | Furniture | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-TA-10004289
21 | Heather Kirkland | Furniture | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | FUR-FU-10002960
22 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-LA-10000240
23 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10002365
24 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10003656
25 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10002311
26 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10004186
27 | Alejandro Grove | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10000107
28 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10003056
29 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10000246
30 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10001634
31 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10000249
32 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-EN-10002986
33 | Ruben Ausman | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10003479
34 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10003282
35 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10001713
36 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10004410
37 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-FA-10000304
38 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10000604
39 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10002671
40 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10000482
41 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10004654
42 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10004182
43 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10002118
44 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10002053
45 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-EN-10000927
46 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10003656
47 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10003442
48 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10004930
49 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10003177
50 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10004738
51 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10001721
52 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10000358
53 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10003256
54 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10004040
55 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10000380
56 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-FA-10000621
57 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10003650
58 | Troy Staebel | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10003274
59 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10001804
60 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10000940
61 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10001058
62 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10003656
63 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10000326
64 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10001950
65 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10001547
66 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-LA-10002475
67 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10002751
68 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-EN-10001990
69 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10004002
70 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10004441
71 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10000659
72 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10000891
73 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10002684
74 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10001940
75 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10003455
76 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10001890
77 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10001328
78 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-EN-10001509
79 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AR-10004685
80 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-ST-10001414
81 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-BI-10000343
82 | [NAME] | Office Supplies | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-PA-10002666
83 | [NAME] | Office Supplies | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | OFF-AP-10003217
84 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-PH-10004977
85 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-PH-10004093
86 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10000171
87 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10002167
88 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10004633
89 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10001998
90 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10001552
91 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10003499
92 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10000844
93 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-PH-10002293
94 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-PH-10000215
95 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10003657
96 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-PH-10003273
97 | [NAME] | Technology | Coustomer | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-AC-10002323
98 | [NAME] | Technology | Corporate | [NAME] | WareHouse | 2023-02-27 00:00:00 | TEC-PH-10001918