Data validation

Dear All,

I have a Drop down list, i want a formating or formula, that help.
If I chose a area from the drop down, the km will come to the next cell automatically..

attaching the same workbook

In cell D16 put the formula:

=VLOOKUP(C16,A17:B21,2,FALSE)

Thanks A lot its working nice...but when Dragging to below cells, the selected source is not remaining the same, how can i fixed the selection area of vlookup?

Senjuti

Use $ signs to lock the references in place, eg.

=VLOOKUP(C16,$A$17:$B$21,2,FALSE)