Link to home
Start Free TrialLog in
Avatar of activematx
activematxFlag for United States of America

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.
User generated image
And the second sheet contains data like this:  
User generated image
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.
Avatar of JP
JP
Flag of United States of America image

Here you go. File is attached.
Copy-of-Combined-Inventory.xlsx
ASKER CERTIFIED SOLUTION
Avatar of JP
JP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial