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

SL.NO | Customer Name | LOD | SOB | Product ID | TMS
1 | [NAME] Gute1(B1) | XXXX | XXXX | FUR-BO-10001798
2 | [NAME] | XXXX | XXXX | FUR-TA-10000577
3 | [NAME]) | XXXX | XXXX | FUR-FU-10001487
4 | Sandra Flanagan2 | XXXX | XXXX | FUR-CH-10002774
5 | [NAME]) | XXXX | XXXX | FUR-TA-10000577
6 | [NAME]) | XXXX | XXXX | FUR-BO-10004834
7 | [NAME]) | XXXX | XXXX | FUR-CH-10001146
8 | Joel Eaton1 | XXXX | XXXX | FUR-CH-10000513
9 | [NAME]) | XXXX | XXXX | FUR-FU-10000629
10 | [NAME]) | XXXX | XXXX | FUR-FU-10001934
11 | [NAME]) | XXXX | XXXX | FUR-TA-10001768
12 | [NAME]) | XXXX | XXXX | FUR-FU-10002157
13 | [NAME] Dominguez1 | XXXX | XXXX | FUR-CH-10004063
14 | [NAME]) | XXXX | XXXX | FUR-TA-10004534
15 | Lindsay Shagiari2 | XXXX | XXXX | FUR-CH-10001146
16 | [NAME]) | XXXX | XXXX | FUR-FU-10004848
17 | [NAME]) | XXXX | XXXX | FUR-FU-10000521
18 | [NAME]) | XXXX | XXXX | FUR-CH-10004063
19 | [NAME] Packer1 | XXXX | XXXX | FUR-BO-10002613
20 | [NAME]) | XXXX | XXXX | FUR-TA-10004289
21 | Heather Kirkland(B1) | XXXX | XXXX | FUR-FU-10002960
22 | [NAME]) | XXXX | XXXX | OFF-LA-10000240
23 | [NAME]) | XXXX | XXXX | OFF-PA-10002365
24 | [NAME] Maddox1 | XXXX | XXXX | OFF-BI-10003656
25 | [NAME]) | XXXX | XXXX | OFF-AP-10002311
26 | [NAME] | XXXX | XXXX | OFF-ST-10004186
27 | Alejandro Grove(B3) | XXXX | XXXX | OFF-ST-10000107
28 | [NAME]) | XXXX | XXXX | OFF-AR-10003056
29 | [NAME]) | XXXX | XXXX | OFF-AR-10000246
30 | [NAME] Hoffmann1 | XXXX | XXXX | OFF-BI-10001634
31 | [NAME]) | XXXX | XXXX | OFF-PA-10000249
32 | [NAME]) | XXXX | XXXX | OFF-EN-10002986
33 | Ruben Ausman(B3) | XXXX | XXXX | OFF-ST-10003479
34 | [NAME]) | XXXX | XXXX | OFF-ST-10003282
35 | [NAME] | XXXX | XXXX | OFF-ST-10001713
36 | Darren Powers(B2) | XXXX | XXXX | OFF-BI-10004410
37 | [NAME] Molinari2 | XXXX | XXXX | OFF-FA-10000304
38 | [NAME]) | XXXX | XXXX | OFF-ST-10000604
39 | [NAME]) | XXXX | XXXX | OFF-AR-10002671
40 | [NAME]) | XXXX | XXXX | OFF-PA-10000482
41 | [NAME] | XXXX | XXXX | OFF-BI-10004654
42 | [NAME]) | XXXX | XXXX | OFF-BI-10004182
43 | [NAME]) | XXXX | XXXX | OFF-AP-10002118
44 | [NAME]) | XXXX | XXXX | OFF-AR-10002053
45 | [NAME]) | XXXX | XXXX | OFF-EN-10000927
46 | [NAME] Schild1 | XXXX | XXXX | OFF-ST-10003656
47 | [NAME]) | XXXX | XXXX | OFF-ST-10003442
48 | [NAME] | XXXX | XXXX | OFF-AR-10004930
49 | [NAME]) | XXXX | XXXX | OFF-PA-10003177
50 | [NAME]) | XXXX | XXXX | OFF-BI-10004738
51 | [NAME]) | XXXX | XXXX | OFF-BI-10001721
52 | [NAME] Rittenbach1 | XXXX | XXXX | OFF-AP-10000358
53 | [NAME]) | XXXX | XXXX | OFF-PA-10003256
54 | [NAME]) | XXXX | XXXX | OFF-PA-10004040
55 | [NAME]) | XXXX | XXXX | OFF-AR-10000380
56 | Ryan Crowe(B1) | XXXX | XXXX | OFF-FA-10000621
57 | Greg Guthrie1 | XXXX | XXXX | OFF-BI-10003650
58 | [NAME]) | XXXX | XXXX | OFF-BI-10003274
59 | [NAME] Creighton2 | XXXX | XXXX | OFF-PA-10001804
60 | [NAME]) | XXXX | XXXX | OFF-AR-10000940
61 | [NAME]) | XXXX | XXXX | OFF-AP-10001058
62 | [NAME]) | XXXX | XXXX | OFF-ST-10003656
63 | Tamara Willingham1 | XXXX | XXXX | OFF-AP-10000326
64 | [NAME]) | XXXX | XXXX | OFF-PA-10001950
65 | [NAME]) | XXXX | XXXX | OFF-AR-10001547
66 | [NAME]) | XXXX | XXXX | OFF-LA-10002475
67 | [NAME]) | XXXX | XXXX | OFF-PA-10002751
68 | Ruben Dartt1 | XXXX | XXXX | OFF-EN-10001990
69 | [NAME]) | XXXX | XXXX | OFF-BI-10004002
70 | [NAME] | XXXX | XXXX | OFF-AR-10004441
71 | [NAME]) | XXXX | XXXX | OFF-PA-10000659
72 | [NAME]) | XXXX | XXXX | OFF-AP-10000891
73 | [NAME]) | XXXX | XXXX | OFF-AP-10002684
74 | [NAME] | XXXX | XXXX | OFF-AR-10001940
75 | [NAME]) | XXXX | XXXX | OFF-ST-10003455
76 | [NAME]) | XXXX | XXXX | OFF-BI-10001890
77 | [NAME]) | XXXX | XXXX | OFF-ST-10001328
78 | [NAME]) | XXXX | XXXX | OFF-EN-10001509
79 | [NAME] Brandow1 | XXXX | XXXX | OFF-AR-10004685
80 | [NAME]) | XXXX | XXXX | OFF-ST-10001414
81 | Fred Hopkins2 | XXXX | XXXX | OFF-BI-10000343
82 | [NAME]) | XXXX | XXXX | OFF-PA-10002666
83 | [NAME]) | XXXX | XXXX | OFF-AP-10003217
84 | Gene Hale(B1) | XXXX | XXXX | TEC-PH-10004977
85 | [NAME] Cazamias1 | XXXX | XXXX | TEC-PH-10004093
86 | [NAME]) | XXXX | XXXX | TEC-AC-10000171
87 | [NAME]) | XXXX | XXXX | TEC-AC-10002167
88 | [NAME]) | XXXX | XXXX | TEC-AC-10004633
89 | [NAME]) | XXXX | XXXX | TEC-AC-10001998
90 | [NAME] Cacioppo1 | XXXX | XXXX | TEC-AC-10001552
91 | [NAME]) | XXXX | XXXX | TEC-AC-10003499
92 | [NAME] Armstrong2 | XXXX | XXXX | TEC-AC-10000844
93 | [NAME]) | XXXX | XXXX | TEC-PH-10002293
94 | [NAME]) | XXXX | XXXX | TEC-PH-10000215
95 | [NAME]) | XXXX | XXXX | TEC-AC-10003657
96 | [NAME] Marley1 | XXXX | XXXX | TEC-PH-10003273
97 | [NAME]) | XXXX | XXXX | TEC-AC-10002323
98 | Laurel Elliston(B1) | XXXX | XXXX | TEC-PH-10001918