Try Again,If,Workday,Vlookup,or Cannot be done!
Posted by L.E. Patton on December 26, 2001 5:27 AM
John gave an answer, but I dont think my example was understood so I will sling it out diffrently.
My Workbook has sheets named for each day of the week.Each day contains values from prev. week (A=prod#, B=value allways). Worksheet named "Production Sheet" has product # and a col. for next day last week (in cell G1)If today was Monday G1 would =Tuesday
What formula would look at cell G1, go to same daily sheet(Tuesday) find a product no# A1:A200, return the value from B1:B200
Sorry I hope this explains more