C
cra88
I am trying to populate a field based on matching 2 different lists. I want
to populate a cell with the cost per mile based on a drop down box for a
carrier name then a drop down box for destination. For example, if I select
carrier 'ABC' in my drop down box in cell a2, then select my destination
'Atlanta' from drop down box in cell a5, I want the rate per mile in cell a7
to populate from a seperate rate sheet in the workbook. I can't figure out
how to write a formula in cell a7 to look at 2 different lists. The 'rate
sheet' list has multiple carriers with multiple destination. Is this possible
and can someone help?
to populate a cell with the cost per mile based on a drop down box for a
carrier name then a drop down box for destination. For example, if I select
carrier 'ABC' in my drop down box in cell a2, then select my destination
'Atlanta' from drop down box in cell a5, I want the rate per mile in cell a7
to populate from a seperate rate sheet in the workbook. I can't figure out
how to write a formula in cell a7 to look at 2 different lists. The 'rate
sheet' list has multiple carriers with multiple destination. Is this possible
and can someone help?