Hi, welcome to the forum

1st some questions...
is there any relationship between the cities? eg a factor that could be applied?
is there any relationship between the gas and diesel?? eg again, a factor that could be applied?

If either of those 2 could have a factor, then I suggest a small table showing the different cities and their rates, and a vlookup()