Inventory List (V lookup) - Output calculated

[Salil S]

My Columns are:

[TABLE="width: 1236"]
<tbody>[TR]
[TD="class: xl63, width: 101"]Item[/TD]
[TD="class: xl63, width: 101"]Cost[/TD]
[TD="class: xl63, width: 101"]Value In Hand[/TD]
[TD="class: xl63, width: 101"]Requested On[/TD]
[TD="class: xl63, width: 101"]Requested For[/TD]
[TD="class: xl63, width: 101"]Recieved On[/TD]
[TD="class: xl64, width: 101"]Open Stock[/TD]
[TD="class: xl66, width: 101"]Quantity Recieved[/TD]
[TD="class: xl67, width: 125"]Dispatched Quantity[/TD]
[TD="class: xl63, width: 101"]Dispatched to:[/TD]
[TD="class: xl67, width: 101"]Discarded[/TD]
[TD="class: xl65, width: 101"]In Stock[/TD]
[/TR]
</tbody>[/TABLE]


Now,
Open Stock = Quantity Received (Manual Entry) + In Stock

Question is:

In Stock should be = VLOOKUP Item name, pick open stock deduct Dispatched Quantity & Discarded. For now I am getting 0.

Then I plan to create a dashboard to reflect stock on today's date for all 15 items as a grid on a another sheet.

How do I resolve these two calculations?

Regards,
Salil.

 

[istiasztalos]

Hi Salil,

Vlookup what & from where?

Also if I read your description correctly 'Open Stock' relies on 'In Stock', and vice versa, 'In Stock' is calculated based on 'Open Stock', what exactly are you trying to calculate with formula and what is given data?

Thanks

 

[Salil S]

Hey istiasztalos,

I was over engineering things. My apologies. I was able to resolve it with moving to three sheets with database, daily entry & dashboard.

It's just one of those times when you overdo yourself

Thanks!