Iterating one array by another

I'm having trouble with my arrays in my code. When I try to pull things from excel forms, everything gets messed up, but when I initialize all the variables in my code, it seems to work. I'm starting to think my problem may be that Range uses two dimensional arrays, while I really only am using a 1D array. Any way to pull the data from excel without it being in a 2D array?

Here's what I had initially (with variables defined in the code)

Please Login or Register  to view this content.

When I used arrays that pulled from excel, the line that utilized my distance variable stopped working correctly. Here is what I have now:

Please Login or Register  to view this content.

The thing is, I want to iterate Distance by HospitalNICUBeds, but I can't figure out how to do it when using the For Each function. Thanks for your help!