Excel formula
- or -
Post a project like this2828
$$
- Posted:
- Proposals: 4
- Remote
- #1202467
- Awarded
Description
Experience Level: Intermediate
I need help in writing an excel formula which combines values from two excel sheets.
Basically I have an excel inventory containing 1000 products which I am permitted to sell - the manufacturer supplies a frequently updated inventory stock sheet, however it contains 1500 products (includes 500 which I am not permitted to sell)
There are corresponding product codes but the stock sheet has additional ones that appear in different places throughout the list - so a simple data sort won't bring the extra ones to the top etc.
I need a formula that scans the product codes (say column A) in the stock sheet and looks them up in my inventory - on finding, it needs to place a stock quantity in a separate column (say column C). I have managed to do this to a degree myself but when the formula finds a product code in the stock sheet that does not appear in my inventory it stops working (in my case it is always on row 23).
The stock sheet updates every day and is available to me via download - i need to merge the data provided with my inventory so that I can upload to my Amazon seller account on a regular basis.
Basically I have an excel inventory containing 1000 products which I am permitted to sell - the manufacturer supplies a frequently updated inventory stock sheet, however it contains 1500 products (includes 500 which I am not permitted to sell)
There are corresponding product codes but the stock sheet has additional ones that appear in different places throughout the list - so a simple data sort won't bring the extra ones to the top etc.
I need a formula that scans the product codes (say column A) in the stock sheet and looks them up in my inventory - on finding, it needs to place a stock quantity in a separate column (say column C). I have managed to do this to a degree myself but when the formula finds a product code in the stock sheet that does not appear in my inventory it stops working (in my case it is always on row 23).
The stock sheet updates every day and is available to me via download - i need to merge the data provided with my inventory so that I can upload to my Amazon seller account on a regular basis.
Sean C.
100% (1)Projects Completed
4
Freelancers worked with
4
Projects awarded
20%
Last project
29 Jun 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies