Hi i am trying to find a way so that when ever a city and state match it pulls the information from another worksheet that has the distance and location and puts that in the notes of my first worksheet.
So for example State K and City L match on the Ref Tab i would like the notes Q to pull the Miles C time D Location E and county F.
Thanks in advance for any help you can give on this one
So for example State K and City L match on the Ref Tab i would like the notes Q to pull the Miles C time D Location E and county F.
Thanks in advance for any help you can give on this one