VB for Excel 2003, matrix question
Posted on 2006-04-12
I have a matrix of locations and milages that form a grid to figure out how many miles you have traveled from point a to point b.
I only really know about select case, and IF statements, but is there a better way to select info out of a matrix? Say if a user selects location2 for their starting point, and then location 10 for their destination, I would need a user defined function to look up on the matrix and pull out the correct distance traveled. That distance then needs to be placed in a resulting cell.
So I should have 3 variables right? One for loc1, one for loc2 and then one to store the destination?
Thanks for pointing me in the right direction.