Hello. I have a list of inventory skus that have purchase transactions across the columns. I want to be able to grab the corresponding price into the sales numbers for each year. There is no matching year, but rather the inventory just runs down from left (on the top table) to right. In cells C8, I've calculated the correct COGS but I wanted to know how I can create a lookup formula that grabs the correct price for the units for all the skus. Spreadsheet attached.
As per your data matter not clear.
Please note that, The basic COG calculation is as per below :
Beginning Inventory Costs (at the beginning of the year)
Plus Additional Inventory Cost (inventory purchased during the year)
Minus Ending Inventory (at the end of the year)
Equals Cost of Goods Sold
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I know what COG calculation is.
I'm using FIFO so......if you look at my data sheet what I'm trying to do is grab the associated price from left to right. What is not clear about it?
This looks to be basically the same question as the one you asked in this thread. If so please close this thread and reply to the proposed solution from the other thread.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks