I'm not sure if this has been addressed before but I am looking for a formula that would allow me to pull data from one sheet to another. Something like this.... If the info matches up I want to pull the city from Sheet 2 to sheet 1. I can't just sort and add because there's more information on one sheet than the other. Hope that makes sense.