Example attachment for drop down menus and functions post

[pyzikchr]

An example of what I'm trying to do, probably would help generate some
better responses.

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=646989

 

[Max]

One way ..

Put in E6:

=IF(OR(COUNTIF(C66,"A")<>1,C6="",D6=""),"Recheck entries in col C and/or
col D",OFFSET($H$5,MATCH(IF(D6<>"A",D6,C6),$G$6:$G$10,0),))

Copy E6 down to E9

The above assumes that point "A" (the starting point)
will appear either in col C or D for every pair of values
in C69

The formula includes some error-traps to help check
that the selections made in cols C and D are valid entries
for the mileage extraction