Problems with =VLOOKUP formula

I have a budget spreadsheet I am trying to improve. In one section, I have a dropdown menu of locations and I want the next column over to auto populate km once a selection has been made (and then the column over calculates a mileage rate in $). I have a table with all the locations and km on a different sheet.

I think I nee to use =VLOOKUP in the column I want autopopulated, but I am having trouble with the exact formula needed.

Any suggestions?