[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Find matching sku put qty in column next to it

Posted on 2012-09-21
2
Medium Priority
?
568 Views
Last Modified: 2012-09-21
Hello,

Is it possible to grab the sku in column E on SHEET 'skus' and check it against the column A on SHEET 'qty' if it finds a match then it grabs the quantity from column E and puts it next to the matching sku on sheet 'skus'?

I have attached the sample doc.

Thanks for any help, this would save me hours of manually searching hundreds of rows.

Matt
sample-data.xlsx
0
Comment
Question by:movieprodw
2 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 2000 total points
ID: 38423853
You can use the SUMIF function. On the skus worksheet in F2 place this formula:

=SUMIF(qty!A2:A5,E2,qty!E2:E5)

Copy it and paste down. Adjust the ranges as needed (A2:A???? and E2:E????)

Flyster
0
 
LVL 1

Author Closing Comment

by:movieprodw
ID: 38423865
Awesome! Thanks, I had no idea it was that easy
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

872 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