Spreadsheet: 831040d1685368586-need-formula-to-vlookup-value-with-criteria-result-of-product-id-nmaes_lookup_-ans
Sheet: Product ID

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