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.