Hey guys - i'm new to this site, so not sure if i will accurately be able to describe what i'm looking for.. but here goes! I'm trying to get info from sheet 1 (production schedule) into sheet 2 (inventory). In Sheet 1 B & C are the product columns & In Sheet 2 Columns A & B are a product code and product description.
In Sheet 1, there are approx 2 weeks of production schedules hidden, but starting in AB - BF, i would like to get the quantities displayed onto the cooresponding dates on sheet 2.
In Sheet 2 Columns C - N are irrelevant for this formula, but i wanted to include this so my formulas would be accurate. In Column Q I will need to display 0 if there is none of this item being produced that day. However if there was something being produced, i would need to indicate the number listed on sheet 1.
I sure hope this makes some sense... i tried a vlookup with a match formula and could not get it to provide anything except #N/A.
Thanks in advance..
Bookmarks