These charts are imported from PC Miler and in one column there is the state, and in the column next to it, there are the miles per state. In the worksheet Origin Destination, there is a chart with a column for each state. What I need, is a formula, that will take all the miles for each state from sheet 1, and put them in the column for each state in the Origin destination Worksheet. Not all the charts in Sheet 1 will have the same states, nor will they be in the same order. So, if you look at the spreadsheet that I added, if we take Illinois for example, in the Origin destination worksheet, we need to have under Illinois 179,500 and 333. I filled those out just as an example of how I need it to look, but i need a formula that will recognize all the miles per each state, and put them in the correct column.
Please let me know if you can help.
here is the spreadsheet.