View Full Version : Return corresponding match count

10-05-2013, 08:53 AM
A car has a current Location and a corresponding destination (same row but different column).
The destination is fixed however the # of cars per location can change per day.
For instance, destination #1 may have 3 cars at location #4 and 1 car at location #2.
For each destination I would like list the corresponding state for the locations corresponding to a given destination.
Example below:
Dest #1 has the corresponding locations 1-Loc #2 (1-CA), 2-Loc #3 (2-MN).
I'd prefer this be acheived in VBA however an Excel formula works well.
Assistance is greatly appreciated.

10-05-2013, 01:53 PM
Based upon my little experience with formulas using VBA, the worksheet formulas execute much faster.