activematx
asked on
Excel - Vlookup? - How do I put contents into appropriate cells?
Hi Experts,
I have attached my file as an example: Combined-Inventory.xlsx
Inside of this file, there are two sheets. The main sheet where I need my data to go (Combined) and another sheet which has data I need to reference.
And the second sheet contains data like this:
I need to reference the PLU numbers to the amount we counted. If someone could help me with the HAVO section, I could understand the formula enough where I could do our other areas (HALE, KAHO, PUHO, PUHE, Etc).
I think this requries a vlookup formula.... but I could be wrong.
I have attached my file as an example: Combined-Inventory.xlsx
Inside of this file, there are two sheets. The main sheet where I need my data to go (Combined) and another sheet which has data I need to reference.
And the second sheet contains data like this:
I need to reference the PLU numbers to the amount we counted. If someone could help me with the HAVO section, I could understand the formula enough where I could do our other areas (HALE, KAHO, PUHO, PUHE, Etc).
I think this requries a vlookup formula.... but I could be wrong.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Copy-of-Combined-Inventory.xlsx