Unstructured Data Look Up


I’m trying to figure out a way to make my forecasting easier. I get a pdf that I convert into an excel file. The dates available for what they forecast is about 6 months worth. The dates and the quantity change every week. 

I’ve pasted it to a google doc for reference, you can locate it here – https://docs.google.com/spreadsheets/d/10SFa4m4Xt83frXQANoJnECAgaVXpFymSHRYvgYj11qE/edit?usp=sharing

I’m trying to have the date and the quantity pulled from this sheet so it can be tallied up by month. and then that figure can be inserted into my forecast program. I’ve shown how I thought the data should be configured. I might be wrong. The values will constantly change. 

I’ve tried Index/Match, I’ve tried to restructure the data on another sheet but it’s very time-consuming. 

Any ideas are much appreciated. 


By: Jeff

Leave a Reply

Your email address will not be published. Required fields are marked *