V Lookup & Indirect Funtion!!

Hello Friends,

I have been trying to create a stock sheet for a friend of mine & got stuck on few things.

1. Not able to change date to dd/mm/yyyy format on Product Received & Product issued worksheet. In turn, want it to show the month through formula in next cell.

2. Is there any way, to show Present stock status in product issued sheet for the item in question. I tried SUMIF formula but must be doing something wrong as it doesnt pick data for current product item selected.

3. Wish to display all the items in the dependent list by selecting the value in the main list on Stock report sheet. This can be done using Vlookup & indirect function that i have googled so far but not able to apply it correctly.

Attaching the file for the reference. Any help or a clue will be much appreciated.

Thank you!!

GV.

Thanks for helping me out... I have filled in some date for you to understand the functioning of the sheet. There are 4 worksheets in the file.
1. Product - Just for reference for someone who is filling the file to know which product falls in which category.
2. Product Received - is for all the products received... I have used a dependent list function the product in the individual category
3. Product Issued - if for issuing the product.. Here i was looking to insert a function which gives present stock of the product whenever any of the product selected.
4. Stock Report.. This is for report purpose as the name suggest... was looking forward to a formula with which i can display all the products of a category by selecting the value from the list above... Highlighted in Green.

Thanks again for helping me out here.

We are pretty close.... I want to display ONLY the Product & unit by selecting the value at the top (Highlighted in Green)... rest of the options Stock Received & Stock issued, i was planning to do with SUMIF function!!

So if you could just make only the product & unit appear once someone select the value at the top... one of my problem will be solved.

You did it with IFError formula... i was trying to understand it... but understood half of it!!

Thank you... you are great.

Problem with date is: In Product Received & product issued worksheet, the date column is showing date in mm/dd/yyyy format even after i selected dd/mm/yyyy from format cell option.

Hello... FDibbins, Did you get a chance to look at it??