the formula I posted only looked in the row for the specified city-not sure why you think otherwise?