Example attachment for drop down menus and functions post

  • Thread starter Thread starter pyzikchr
  • Start date Start date
One way ..

Put in E6:

=IF(OR(COUNTIF(C6:D6,"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 C6:D9

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
 
Back
Top