Inventory List (V lookup) - Output calculated

[Salil S]

My Columns are:

Item

Cost

Value In Hand

Requested On

Requested For

Recieved On

Open Stock

Quantity Recieved

Dispatched Quantity

Dispatched to:

Discarded

In Stock

<tbody>
</tbody>

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!