quick job - google sheet adjustment needed
Budget: $10 – $30 CAD
I am looking for a google sheet specialist to enhance the functionality of an existing spreadsheet that contains two key tabs: 'Order' and 'Inventory'. The primary task involves creating a sophisticated formula in the 'Order' tab.
Key Requirements:
Understanding the Spreadsheet Structure:
The 'Inventory' tab contains a comprehensive table with critical information. The first column includes IPM codes (unique identifiers for my company's products).
Developing a Formula: The crucial task is to develop an Excel formula that enables automatic population of data in the 'Order' tab. When an IPM code (e.g., 'A1') is entered, the formula should auto-fill corresponding row details such as FORMAT, CODE PRODUIT, DESCRIPTION, and PRIX from the 'Inventory' tab.
Ensuring Accuracy and Efficiency: The formula should be accurate and efficient, reducing manual data entry and potential errors.
If you have the skills and experience required for this project, please submit your proposal with your relevant experience and a timeline for completion. Thank you!
Key Requirements:
Understanding the Spreadsheet Structure:
The 'Inventory' tab contains a comprehensive table with critical information. The first column includes IPM codes (unique identifiers for my company's products).
Developing a Formula: The crucial task is to develop an Excel formula that enables automatic population of data in the 'Order' tab. When an IPM code (e.g., 'A1') is entered, the formula should auto-fill corresponding row details such as FORMAT, CODE PRODUIT, DESCRIPTION, and PRIX from the 'Inventory' tab.
Ensuring Accuracy and Efficiency: The formula should be accurate and efficient, reducing manual data entry and potential errors.
If you have the skills and experience required for this project, please submit your proposal with your relevant experience and a timeline for completion. Thank you!