[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
Medium Priority
568 Views
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
Question by:movieprodw

LVL 22

Accepted Solution

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

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

## Featured Post

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…
###### Suggested Courses
Course of the Month19 days, 11 hours left to enroll