"I want to be able to use VLOOKUP." "I want to know how to use it in practice within the factory." If you are such a person, please read on!
"I have learned to use the SUM function and the IF function in Excel. What function should I study next?" "It seems that the VLOOKUP function is convenient, but I don't know how to use it specifically." "How is VLOOKUP used in manufacturing sites?" This document has been created for those who have such concerns. Once you can use VLOOKUP, you can consolidate data scattered in various places into a single table. In this document, we will introduce a case of combining two tables: one that summarizes the departments responsible for each part and another that summarizes the inventory count for each part.
Inquire About This Product
Related Videos
basic information
The catalog download is free, so please feel free to download it!
Price range
Delivery Time
Applications/Examples of results
Gas appliances, air conditioning equipment, medical devices, semiconductor-related items, etc.
catalog（2）
Download All Catalogs
Company information
Matsui Manufacturing Co., Ltd. focuses on non-ferrous metals such as copper, brass, and aluminum, offering a consistent production system from hot forging to machining, pipe bending, brazing, and unit assembly. We propose suitable QCD (Quality, Cost, Delivery) to our customers from our four production bases located in Japan and abroad (Osaka, Tottori, Himeji, and China). Since our establishment in 1948 as a manufacturer of gas appliance parts, we have developed and manufactured various control devices related to gas appliances, petroleum, water, and air conditioning, marking half a century of history with the motto of "Customer First." We will continue to acquire advanced technologies, promote flexible thinking that breaks away from conventional concepts, and not only respond to user needs but also proactively propose solutions that anticipate the needs of end users. We look forward to your continued guidance and support.