general question :Multi-dimensional arrays

[brillig12]

Hi,

This is a general question about how it's possible to use arrays in VBA.

What I am trying to do is use a 2 dimensional array to store the names of employees and their normal start time for work for each day of the week.

Unless I'm mistaken then this should be possible by using an array as shown below:

Please Login or Register  to view this content.

What I want to do is define the first dimension as the name and the second dimension as the day and then be able to find the time for a specific employee on a specific day by matching their name and the day. This is where I am at a loss for what to do.

I can load the data into the array one value at a time.

Please Login or Register  to view this content.

But this does not allow me to reference that time by the name or the day directly, only by their numerical order in the array.

I hope this is not a stupid question, causing many to roll their eyes but I know I can make a significant advancement using arrays but need a little help to find my feet.

If I've left any key details out or more info is needed please let me know.

Thanks

[shg]

Like this?

Please Login or Register  to view this content.

Or this:

Please Login or Register  to view this content.

[mikerickson]

I'd tend to use a VLOOKUP table on a worksheet rather than hardcoding values. (Its easier to change and maintain.) But the VLOOKUP function can be used with arrays as well as ranges

Please Login or Register  to view this content.

[brillig12]

Thanks. That's incredibily useful. I kept getting lost in the idea that the name had to be defined in the first variable rather than being the first entry i the second.

Thanks!