Excel Formula for Item Quantity Retrieval

Job ID: 38724507

Budget: $10 – $30 USD

I'm looking for an Excel expert who can create a formula for me. The task is to reference specific item numbers from an existing spreadsheet and pull in the full pallet quantity with a round down logic applied.

- The data to be used is from a single column in my existing spreadsheet.
- The formula should be able to handle referencing specific item numbers and pulling the corresponding quantities accurately.
- The round down logic should be applied to the full pallet quantities.

Ideal candidates for this project would be those with extensive experience in Excel, particularly in creating complex formulas. Understanding of inventory management terminology would be a plus.
Related categories: Visual Basic Data Processing Data Entry Excel