Solved

Excel - Vlookup? - How do I put contents into appropriate cells?

Posted on 2011-09-06
2
180 Views
Last Modified: 2012-05-12
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.
Sheet 1
And the second sheet contains data like this:  
Sheet 2
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.
0
Comment
Question by:activematx
  • 2
2 Comments
 
LVL 14

Expert Comment

by:peetjh
ID: 36492121
Here you go. File is attached.
Copy-of-Combined-Inventory.xlsx
0
 
LVL 14

Accepted Solution

by:
peetjh earned 500 total points
ID: 36492166
This formula would remove the NA values and replace them with 0. Place it in F4 and copy down.

=IF(ISNA(VLOOKUP(B4,HAVO!A:B,2,FALSE))=TRUE,0,VLOOKUP(B4,HAVO!A:B,2,FALSE))
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now