lookup and return value from reference table

  • hey everyone, i am new to excel and i really need some help with this assignment. i have only learnt vlookup, indirect, if formulas so far, and i have no idea how to come up with a formula that autofill to the right. im suppose to look up values from the chart below and according to the city i enter in A3 and A5, i will return the value in the row. i used =vlookup($A$3,milechart,2), but that only returns to the 2nd column, as i move down the row, using another via city. the column number "2" won't move to "3". so it won't return the correct value.

    Thank you so much for your help.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!