Hi all,

I'm trying to save myself a mountain of time by VLooking up a multi criteria.

I've created a mountain of history for all possible outcomes for deviated mileage on a number of delivery routes (i work in transport by the way).

My history in basic consists of a number of deliveries to reoccuring customers but in different sequences.

Eg

Monday - ABCD
Tuesday - BCAD
Wednesday - CDEBA
Thursday - ACB
Friday - DCBAE

Blah blah and so forth.

The chances are that the pattern emerges again somewhere down the history but i need a quicker way of searching for it.

Is there any way i can create a search page with 5 headings "Customer 1, Customer 2, Customer 3...........etc." And create a data validation to select the customers and then that in turn searches for the same sequence of deliveries and gives me the deviated mileage specified in the last column.

Hope this makes sense.

Any help appreciated.